lol, thanks Sean... shot in the dark I know, I am posting on mdsn as well thanks.

there is an upload feature built in to SSRS. From the web interface you should see an "upload" button if you have the appropriate permissions. This will allow...

When you use the literal range in the select statement it limits the cube result in advance of processing the result.

The set is not being defined until later in the...

Guenter,

thanks for the reply.

I am using a pivot table to display the result set, but what I am trying to display is a calculated member from the cube based on...

if you can post your mdx I might be able to assist.

Hi, thanks for the reply, but you guess incorrectly. I am well aware of the intent of BI.

What is being analysed is a series of forecasted values....

It appears you need to add your source control plugin to visual studio before it will appear in the dropdown.

http://msdn.microsoft.com/en-us/library/bb166193.aspx

Not sure if your dataset is fixed or dynamic, but you could

add a row count to your dataset and create 10 tables in the report, then place a filter on...

If you are getting results, but not the right results... it is probably an issue with the hierarchy attributes in the dimension.

When you view your hierarchy in BIDS are there...

Alsanhanc,

the error is due to the syntax you have in the second portion of the mdx. [Tri Annee] must be removed for the calculation to work.

Patrick,

have you tried processing the cube through analysis services independent of the ssis package? This will display specific details of the processing error. i.e. which primary keys are...

that is strange... parent should be an aggregated value.

if you create a calculated member of the parent portion and browse, what does it return?

Robb,

try and use your measure explicitly in the numerator and denominator... and try dimension parent in the denominator or root. ie:

([Task Data].[Task Category].&[Client Related Time],[measures].[value])/ ([Task Data].[Task Category].parent, [measures].[value])

([Task...

try

([Task Data].[Task Category].&[Client Related Time] / (sum([Task Data].[Task Category].[All])))

works like a charm!

thanks for your help 🙂