I have a scorecard which I would like to filter the data using MDX filter expressions. I have got the MDX filter expression which consists of a filter applied on 2 columns, but I am just missing the l
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
I have the following structure of measures and dimensions, and some example data Fact Table: id_dim1 id_dim2 id_dim ...measure1
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 am having a dimension named PERIOD with three levels YEAR, QUARTER and MONTH. I have filtered out third level data as follows:
i need to SUM the results of multiple queries. the challenge that i have is that each query has defined members (to calculate a date range)
When creating a dashboard in PerformancePoint Services (PPS), I often resort to custom MDX in a number of areas:
I\'m trying to permanently create a ca开发者_高级运维lculated dimension member using a MDX ADOMD command from C# code.
I have a SQL stored proc that uses a linked server and Openquery to execute a MDX query.The result returned from the MDX query is in the format of:
加载中,请稍侯......