I have one data warehouse table that contain one row for each item sold. Each row contains the item's type. What MDX request could show the number of items sold for each item type? What (dimensions,levels,etc) would it suppose to create? In case it is relevant, I am using Pentaho/Mondrian/Spoon/Schema Workbench. ...
In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. This displays the required data. I want to know if there is a way to view the MDX query being generated behind the scenes to display the data? Thanks. ...
Can you provide me the tutorial for SSAS 2008 which also includes learning MDX queries also ? ...
I'm trying to set up a cube calculation. My current remit is that I will receive exchange rates, and these will be sent at the start of the month. Sometimes they will change during the month, and I will receive a rate to use for that currency onwards. The initial problem is that LastNonEmpty uses the granularity questioned, which means ...
I'm currently struggling with the creation of a cube. Below is a simplified version of my relational data... Race Id Type Total 1 A 3 2 A 2 Result Id RaceId Gender Position 1 1 M 2 2 1 M 3 3 1 F 1 4 2 F 2 5 2 F 1 In some...
Hello, I have a MDX query that needs to agg some data but filter on leaf nodes. I have a way to do it using DEPENDENTS and EXCEPT, but there can be 10's of thousands of leaf nodes, and filtering out is taking quite a bit of time SELECT { [Measures].[Field1], [Measures].[Field2], [Measures].[Field3], [Me...
Suppose I have a [Sales] cube which has a [Store] level and a store has a "type" property. Which query should I use for showing the sum of sales for all the stores of type "Supermarket"? (e.g. You sold 6M $ in all stores of type "Supermarket") ...
hello Friends How can I return Analysis Services properties which is stored in the XML using MDX?? ...
Can you provide me tutorial for writing MDX and sample MDX queries especially, since I have not been used to MDX ? ...
I need to perform a calculation in SSAS which only applies to the current and future months (it can't be applied retrospectively using the available data). I can do this by using the calendar hierarchy and hard coding today's month as follows... SCOPE([Measures].[RollingStock]); ([Dim Date].[Calendar].[Month].&[201008]:NULL...
In analysis services, I have cube that is based on hospitalization data. For each hospitalization there are potentially 9 icd codes and these are each stored in their own field in the view on which the cube is based. These are stored in a child table in the relational database on which the SSAS database is based. I would like to query...
hi if i pass my mdx like this i am get what i am expecting.. With Set [TimeLimit] as '{([CurrDate].[All CurrDate].[2010].[Q3].[Jul].[2010-07-21])}' select NON EMPTY {[Measures].[Balance], [Measures].[Peso Equiv]} ON COLUMNS, NON EMPTY { [PARTICULARS].[All Particulars], [PARTICULARS].[All Particulars].[RESIDENTS], [PARTICUL...
hi , if i use this one,my query is working... " where ([PRODUCT].[All Product].[Debt Securities].[Available for Sale], [REPORT DATE.RUNNING_DATE].[All Report Date], [Transaction type].[All Transaction type].[PURCHASE INSTRUMENT])" but i want to replace [REPORT DATE.RUNNING_DATE].[All Report Date] with Tail(Descendants([REPORT DATE]....
Hi, I'm writing an SSRS 2005 report based on our cube that contains a prcoedure dimension. I need to setup the report such that it contains only those patient records that has one or more defined procedure codes. My research thus far has pointed me toward creation of a query parameter in my report's dataset. Would this be the corre...
Hello, I am building a Report in MS Visual Studio which gets its data from a cube. This has amongst others a dimension called Player. I want to hand over a parameter 'Name' and receive the number of games the player has played. But I do not get the parameter integrated in the MDX-query I use. I had defined the parameter and in the query...
I need a MDX query which returns the top N percent of the rows based on a cumulative sum of a measure. The tricky part is that the set must be ordered based on a different measure than is used for the sum, so using the TopPercent function is not possible. To clarify what I need, here's an example. I want to buy at least 1000 grams of me...
I have within an MDX query the following calculated member: MEMBER [Asset].[Class].[Fixed Income Derivatives (Inflation Linked)] AS ( [Asset].[Class].&[Fixed Income], [Asset].[Sub Class].&[Derivatives], [Asset].[Sub Class Type].&[Inflation] ) This is used within a query as follows: SELECT { [Measures].[Market Value] } O...
Category {A,B,C} Value Currently I can get: Category Value -------- ----- A 100 B 200 C 300 What I'd like to get is: Category Value -------- ----- A 100 B 200 C 300 D 500 Where D is the value of B + C. ...
Can I use the sine function within MDX? I would like to know the sine of a measure. ...
I have the following star schema: Objects <-> Facts <-> Simulation -ObjectID -ObjectID -SimulationID -SimulationID -SimulationID -ObjHierarchy -Volume -ObjectType Now I'm trying to filter the cube using both dimensions: select [Measures].[Volume] on columns, [Objects].[ObjHierarchy].[Level 0...