Search Results | SQL Server Performance Forums

Strange behaviour of time dimension

Post by: ritika.thakkar, Mar 2, 2007 in forum: SQL Server 2005 Analysis Services

i have tried this ranjit, but it still doesnt work :-(

Strange behaviour of time dimension

Post by: ritika.thakkar, Mar 2, 2007 in forum: SQL Server 2005 Analysis Services

This is the MDX query i am firing: select [Measures].[Sales Value Base] on columns, [Merchandise].[Reporting Dept].members on rows from [IRS Cube]...

Strange behaviour of time dimension

Thread by: ritika.thakkar, Mar 1, 2007, 4 replies, in forum: SQL Server 2005 Analysis Services

Hi, I have a time dimension which is connected to a sales fact. The dimension has an attribute year, having 2 values curently, 2005 and 2006. There...

Connecting to a cube using SSIS

Post by: ritika.thakkar, Mar 1, 2007 in forum: SQL Server 2005 Analysis Services

Ranjit, I got the error. Actually i had forgotten to specify the axis for the fileds in the MDX query, hence i got the error. And as for not being...

Connecting to a cube using SSIS

Thread by: ritika.thakkar, Feb 28, 2007, 3 replies, in forum: SQL Server 2005 Analysis Services

Hi, I am trying to connect to a cube using SSIS. These are the steps i am following: 1. i have created a new package. 2 Next i added a data flow...

aggregating data according to user selection

Thread by: ritika.thakkar, Feb 27, 2007, 0 replies, in forum: SQL Server 2005 Analysis Services

Hi, I have built a cube which has a product dimension and sales fact. There is a proper hierarchy defined in the product dimension which goes from...

Pump Aggregated Data from Cube to OLTP database

Post by: ritika.thakkar, Feb 26, 2007 in forum: SQL Server 2005 Analysis Services

Hi Ranjit, I am stuck in a similiar situation as Madhu's. I need to get aggregated data from my cube into a SQL server database. I have read ur...