Hi there
I'm looking to create a report that will replicate the following Excel example in our third-party OLAP application. I'm struggling to work out the syntax that will enable me to de...
I have a really big query(the code I'm posting is a simple version of my original code) and I really need to have the non_empty_behavior included. The problem is that when I do, I loose a lot ...
I'm having big difficulties with an existing OLAP where the end user uses Excel to pivot the data. The OLAP has 6 dimensions where 5 of the dimension have from 34 to 2266 rows and the last di...
Hello,
I have seen the AdventureWorks 2008 sample and tried to create a drillthrough action in my cube like MS did but I simply get an empty data set when choosing the drill option from the c...
Hello, im trying to list all Databases and their Cubes on SQL Analysis Server 2005 with the code below.
But i only gets the Cube for the first db. (I have four db)
Any idea how to loop throu...
Once I have assigned surrogate keys to my dimension tables, what SSIS process should I use to insert these new keys into the fact table?
I need year to date mdx, and last years year to date. meaning if we are in october now, last years ytd will add up to last years begining to october.
it would be nice if you have both stat...
I have created a dimension which has three products in. Each product can either have a status of 'Yes' or 'No'. I have demornalized the data into the following dimension table. Is this ok?
...
I'm working with a OLAP cube that I want to use in excel to pivot. I need certain dimensions and facts and when I add all of those to the cube when I browse the cube in Management studio it's ...
Hi,
I am building a cube for my client. The time dimension is a little tricky. The fact table has year/month column (values are like 200509) as a key to my period table(time dimension tabl...
Hi everyone,
I'm trying to create a cube calculation to display last year to date in a report.
The report uses a set to filter a Y-W-D hierarchy to display the weeks which have happened ...
I have a member in a dimension which has some Null values.
I don't want the null values to be available when browsing the cube. Is there a way in which I can hide/remove/rename the null va...
I am creating a data warehouse to feed a SSAS cube and I am not sure which columns to include in my dimensions.
Here is an example of my problem/confusion.
In the original source table t...
hello,
my name is John and I'm new to OLAP and MDX.
I have one scenario relating data security and visability that I wanted to check with you whether or not is possible.
Let's say we ha...
Hi,
Is it possible to add a new SSAS dimension to a cube that is already in production without causing a full cube process?. The dimension we wish to add is already in the OLAP database and...
I have a cube that contains a dimension called 'Project'. The 'Project' has different member properties like 'StartDate', 'End Date', 'DlvDate' and 'Customer'.
I have calculated measures: '...
