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 分类：问答