i have tried this ranjit, but it still doesnt work :-(
This is the MDX query i am firing:
select [Measures].[Sales Value Base] on columns,
[Merchandise].[Reporting Dept].members on rows
from [IRS Cube]...
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.
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...
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...
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...
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...
Separate names with a comma.