I didn\'t found but m开发者_运维百科ay be someone could me explain - OLAP cube is a combination of all possible aggregation, so related to Mondrian - leaf level is data in fact table or it is a minimu
I am creating an analysis dashboard using DUNDAS dashboard. For that I have to create an OLAP c开发者_开发问答ube.
I want to write an MDX expression that uses a measure value in the WHERE statement. For example: suppose I want to show the income from sold products in stores in different cities, but I only want t
Im new to MDX Query and I\'m trying to add a percentage on attended percentage in each row.The following code :
I would like to calculate a Measure based o开发者_如何学Pythonn the current row. Problem is I can\'t find a way to get the current row in a WITH MEMBER part.
I bit confuse with Hadoop hive which i read from Wiki used for make OLAP. Now i want to make OLAP on Hive from OLTP database which use Mysql开发者_如何转开发.
I need a complex (in some degree) public dataset for OLAP kind of analysis and reports. Foodmart, AdventureWorks and Steel-Wheels which comes with BI products are focused primary on a single domain -
Am using OLAP a开发者_运维百科nd i want to make measure functions e.g(count,max,..) to be selected by the user (to be as a filter).
So I am working on a project that requires me to make a dropdown using the data from analysis service cube. This is what i have come up with by googling.
I new to OLAP, and still not sure how to create a relationship between 2 or more entities. I am basing my cube on views. For simplicity sake let\'s call them like this: