mdx
MDX Query to return list of customers except customers from previous time periods
I have a trouble writing 2 MDX queries: 1) A query that should return all customers (with corresponding sales amount), which have made a purchase in the last 3 finished months (at least 1 purchase in[详细]
2023-04-12 14:46 分类:问答SSRS Parse UniqueName of a member to display it as date in Using MDX
here is my probl开发者_运维问答em [Time].[Month Hierarchy].[Day].&[2006]&[2]&[26] how to parse the UniqueName above to display like this --> 2006/2/26 using mdx or expression in ssrs[详细]
2023-04-12 10:52 分类:问答MDX Query to Produce Revenue by Top N Advertiser
I need to create a report using SSRS 2008 that will show the top 10 advertisers by revenue.I wrote the MDX query in management studio as follows:[详细]
2023-04-11 13:31 分类:问答how to get rid of empty cells while doing column grouping in SSRS report
I have added a column group in my report, which should work as below. group1 group2 group3 data1d开发者_StackOverflowata1data1[详细]
2023-04-10 12:57 分类:问答Using Cubeset To Create Top 10 Items List For a Specified Time Period
I am using Excel 2010 to create a list of the top 10 vendors by sales during a specified time period. The catch is that I need to consider only customers that are a member of a particular set. I found[详细]
2023-04-07 19:08 分类:问答mdx parameter that contains two words causing an error
I require help of the experts again! I have set up a drop down list to be a parameter of another dataset.[详细]
2023-04-07 04:50 分类:问答How to calculate recent row average value using MDX?
My data example: idvalue_a 11.0 22.0 33.0 44.0 which I want is id / value_a / recent_n_avg 11.00.33 22.01.00 33.02.00[详细]
2023-04-06 13:52 分类:问答MDX not recognizing my expressions as tuple sets?
When I have two members references with the &[Value] syntax being crossjoined, then I get this error:[详细]
2023-04-06 09:20 分类:问答MDX query Count() return null when we put [Account].[Account Number].&[1] in WHERE clause
In our Adventure Works cube, if we run the following query, we will get two null cells back, and it will only happen for some members in Account Number. Does anyone know why?[详细]
2023-04-06 06:34 分类:问答Accessing TFS cube to obtain area hierarchy's unique name
I would like to obtain the unique name of a given area path. I\'ve seen this article of John开发者_JS百科 Socha: http://blogs.socha.com/2009/10/customizing-report-parameters-for-team.html. What I wou[详细]
2023-04-05 19:30 分类:问答