I’m pretty new to the many-to-many dimensions but I have a scenario to solve, which raised a couple of questions that I can’t solve myself… So your help would be highly appreciated! The scenario is: There is a parent-child Categories dimension which has a recursive Categories hierarchy with NonLeafDataVisible set There is a regular Pr...
Hi I was just wondering if anybody knows how to dump mdx query result set into excel. Thanks, Sagar ...
I'm trying to access the KPI metadata via ADOMD.NET (using MDSCHEMA rowsets) with SQL Server/SSAS 2008. When I get a given KPI VALUE field, for example in Adventure Works, it returns what I believe is the hidden measure associated with the KPI (e.g., [Measures].[Net Income Value]). But the Value has areal MDX expression associated with ...
For Sql Server Analysis Services. What im looking for is if anyone has example code of a class or function or a precompiled dll that you can pass columns, rows, pages, with filters etc. This then generates the mdx string. im working in asp.net but should be able to convert from an example in any other language ...
I am looking for SSAS cube and MDX (Multidimensional Expressions) sites like our StackOverflow site. Any other resources for SSAS cubes would be welcome as well. ...
Hi, We have a two-cube solution built in AS 2008 that works like this: an Industry cube that contains Widget data for all clients, and a Client cube that contains Widget data & shares several (but not all) dimensions with the Industry. The Industry cube contains everybody, including the calling client, so when the Client is pulling an ...
Environment: SQL-Server-2005, SSAS 2005 I am using the following formula to create a Moving Annual Total SUM ({[Time].CurrentMember.Lag(3):[Time].CurrentMember}, [Measures].[TRx Quantity]) The same column [Measures].[Trx Quantity] is used in other calculations and it works fine. This one, however, comes up with #Value! to indicate so...
I'm using SQL Server 2005 Analysis Services and I'm trying to calculate distance inside of an MDX query - so that I can get counts of the items that are near my current location. I've created a dimension with Latitude & Longitude, and have also created a .NET assembly to do the math - but am having a hard time getting it all to work out...
This is how I am creating my moving totals as columns in my cube: MATTY (Moving Annual Total This Year) SUM ( { [Time Period].[Month].CURRENTMEMBER.Lag(12) : [Time Period].[Month].CURRENTMEMBER }, [Measures].[MeasureColumnName]) MATLY (Moving Annual Total Last Year) SUM ( { [Time Period].[Month].CURRENTMEMBER.Lag(24) : [Time Period]...
I have a database containing tables with more than 600 million records and a set of stored procedures that make complex search operations on the database. The performance of the stored procedures is so slow even with suitable indexes on the tables. The design of the database is a normal relational db design. I want to change the database...
Hi, I would like to know more about "MDX" (Multidimensional Expressions). What is it? What is it used for? Why would you use it? Is it better than SQL? What is its use in SAP BPS (I haven't seen BPC, just heard that MDX is in it and want to know more)? ...
First some background: I have the typical Date dimension (similar to the one in the Adventure Works cube) and an Account dimension. In my fact table I have daily transaction amounts for the accounts. I need to calculate cumulative transaction amounts for different accounts for different periods of time. The catch is that whatever is the...
I have built a cube that contains ticket sales information. I have a measure that is a distinct count of customer numbers from the fact table. The unsold tickets for each performance are recorded in the fact table and are assigned a "special" customer number that refers to a dummy customer record. I would like to have the distinct coun...
I am trying to match existing reporting functionality while building up a new cube for a Proof of Concept. Can I retrieve data from my cube using an MDX query and put it into a recordset so I can then populate an Excel Sheet with the data? ...
I am new write a pixel shader and use in my managed directx project, where i can get some basic sample to start it. ...
Hi, I'm new to cubes and MDX and have been struggling with this problem for a while now. My fact table has the following columns (Start and End contain dates and times down to the minute level): ID (int) Start (DateTime) End (DateTime), plus other dimensions. I've created a table called DimDateTime that has a sequence of 15 minute i...
Say I have a measure, foo, in a cube, and I have a reporting requirement that users want to see the following measures in a report: total foo total foo excluding instances where foo > 10 total foo excluding instances where foo > 30 What is the best way to handle this? In the past, I have added Named Calculations which return NULL if fo...
I have the following query that gives me an extract (I am putting this into a CSV from my cube). I want to show the Total of all NRx in a column as the first column NRx and the rest of the NRx columns should come up as they do now. I tried to add a SUM (Measures.NRx) to this, but it did not work How do I get a total NRx column? SELECT...
In TSQL I can do Select Column1, Column2, '' as Column3, 0 as Column4 From MyTable I am trying my MDX as: SELECT {Measures.Measure1} ON COLUMNS { Dimension1.DimensionColumn1.DimensionColumn1.Members, '', 0 } ON ROWS FROM [CubeName] This does not work - I get the following error message Executing the query ... Query (1...
I am trying to create a TFS report which requires MDX. I am making a report that requires a calculated member. I am not 100% sure how this is done. The member i am trying to do is a difference calculation. For example: Table Sept 1 Sept 2 Sept 3 Actual 0 32 58 Remaining 163 140 ...