I am trying to build a calculated measure in SSAS that incorporates a dimension parameter. I have two facts: Members & Orders and one Dimension: Date. Members represents all the unique members on my site. Orders are related to members by a fact key representing a unique user. Orders also contains a key representing the vendor for an orde...
I would like to create a calculated measure that sums up only a specific subset of records in my fact table based on a dimension attribute. Given: Dimension Date LedgerLineItem {Charge, Payment, Write-Off, Copay, Credit} Measures LedgerAmount Relationships * LedgerLineItem is a degenerate dimension of FactLedger ...
This is a pretty straight forward question that may or may not be possible but, when you create a measure in a SSAS 2005 cube, there is a description property which can be set, which we've been using in the client application that consumes the cube. Is it possible to set this description when you create a calculated member through MDX? ...
Hello, I'm new to MDX and have a problem regarding filtering out values from a summation. We want to perform normalization calculations, specifically a quantity (q) divided by a basis (b) to get an Intensity (I). The formula is fairly simple I=q/b. OUR CUBE STRUCTURE: We have fact tables FactQuantity and FactBasis, each of which are ...
What I want to do: The report parameter that the user can select from is a subset of the data available in a dimension. I have a query to retrieve this subset and it works fine. I am then trying to use the selection as a filter in a dataset. In the dataset properties, you can add a parameter based on the ones you have specified on the...
I have this mdx query: SELECT NON EMPTY Hierarchize({DrillDownLevel({[Date].[Date].[All]})}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ,[Date].[Date].[Date].[Month] ,[Date].[Date].[Date].[Week] ON COLUMNS ,NON EMPTY Hierarchize({DrillDownLevel({[Work Item].[System_AssignedTo].[All]})}) DIMENSION PROPERT...
Pretty much what the title says. Is it possible to show the MDX that is sent to OLAP source when using a pivot table in Excel 2007? ...
I can get the MAX() of some Measure based on Dimensions specified. I have no issues with that. What I am looking for is Second MAX(). Means if I sort the some Measures in DESC order it is 5,4,3,2,1 With MAX() I can get 5 but I want 4. How do I compute that? ...
I'm a complete newb to MDX / OLAP, "data warehousing" in general. I have the following MDX query and would like my results to display the month's number (1 = January, 12 = December). Luckily, the cube creator created a member property named "Month Number Of Year" When I try to run the query, I get the following... "Query (4, 8) The func...
How can i round a calculated mdx measure up to the nearest integer without having Excel on the server? The Excel-function is CEILING(number, significance), but it is not possible to install Excel on the production ssas-server. ...
I have taken a perfectly working MDX piece of code to Windows 2008R2 (all DX drivers installed) and am getting the following, rather bizarre, error. Any idea what this could mean? System.BadImageFormatException: Could not load file or assembly 'Microsoft.DirectX.Direct3D.dll' or one of its dependencies. is not a valid Win32 application...
I am trying to filter a query by two (multi select) parameters. It works fine when doing this for the first one, but complains when I add the the second one. Is my syntax wrong is there a better way to achieve what I want? ...
...
Hi Guys... I am working on data warehouse project I have built The cube and I 'v Transferred the data to it but now I wanna to query it with MDX language I remember that we can use a designer to choose the measures and dimensions ... but I forgotit please can you guide me step by step and which type of projects I have to create to make m...
I have this problem using MDX: i am trying to set up a keyboard device with the Foreground and Exclusive flags (up until now I let it to Background - which worked - and did the KeyUp / KeyDown events only when the app was focused, but with these settings I recon you can get some antivirus alerts because it could think that the app is a k...
I am customizing one of the CMMI reports in TFS 2010. One of them is "Bug Status". When I open the query in the Query Designer of BIDS, i see that two backslashes (//) are used for comments. But where does the comment stop? It looks like a tab is the stop.... Is there any reference to find about the comment syntax ? Here is the quer...
with member [Measures].[BoughtDispenser] as Sum(Descendants([Customer].[Customer].CurrentMember, [Customer].[Customer]), Iif( (IsEmpty(([Item].[ItemNumber].&[011074], [Measures].[Sale Amount])) And IsEmpty(([Item].[ItemNumber].&[011069], [Measures].[Sale Amount])) ) Or IsEmpty([...
Does anyone know of a way to "extract" the formulas for all calculated members of a cube into some kind of flat, readable file? Alternatively, a less-painful method of getting an overview of the code than using Analysis Services' Cube Editor and clicking on each Calculated Member would be helpful. Yes, I'm new to MDX. Many thanks! ...
Hi, Using : Analysis Services 2008, Excel 2007 I've created a Cube and am able to connect from Excel. Cube does have some Calculated Measures, Named Sets and KPIs. Now, I'm been writing some MDX in MS SQL Server Management Studio. How do I write MDX queries and make them available through the Cube? Can I create Cube Views / Cube spr...
What is the simplest MDX request? I want to test whether my MDX endpoint answers correctly to a very simple request. In SQL, I would say SELECT 1; ...