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
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
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:
I have added a column group in my report, which should work as below. group1 group2 group3 data1d开发者_StackOverflowata1data1
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
I require help of the experts again! I have set up a drop down list to be a parameter of another dataset.
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
When I have two members references with the &[Value] syntax being crossjoined, then I get this error:
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?
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