I fixed this issue by recreating my dimension to drill down to Day level and then creating Sets for calculated measure.

It works fine.

Thanks a lot! It fixed the error.

Thank you, Chris for replying to my post.

I changed the design to make the calculations work. Since there was a single rate to be applied to a group of...

Thank you, Chris! I will research on this topic online to learn more.

Best Regards,

Uma

Hi Chris,

I can browse the cube if I filter by any dimension except customer name.

CustomerNameRateRateAtAllCellsTotalWt

A 1010...

Hi Chris,

I looked at the URL you posted along with the script. After going through the information a couple of times, I was able to make the changes accordingly in...

Hi Chris,

Thank you for the reply. I don't have the rate for each customer in the database. The rate applies to a particular shipment date by shipment truck as it...

Hi Hrvoje,

We use a reporting tool call Targit BI Suite 2008. The users are not using Excel right now to access cube data but they might choose to in future....

Hi Hrvoje,

I created a named set called [Day] with the script {existing [Fiscal Period].[Fiscal Period Hierarchy].[Day]}

Then, I created a calculated measure [LY Quantity] as Aggregate

(generate(

existing [Day],

{parallelperiod([Fiscal Period].[Fiscal Period Hierarchy].[Year],1,[Fiscal Period].[Fiscal...

Hi Hrvoje,

Thank you for the detailed reply. I am new to writing MDX scripts and trying to understand the logic and concept.

Based on your suggestion, I modified my measure...

Hi Steve,

I am creating a calculated measure called [LY Quantity] and this is what I have under the script view for this measure.

CREATE MEMBER CURRENTCUBE.[MEASURES].[LY Quantity]

AS ((existing [Fiscal Period].[Fiscal...

Thank you Ron and Steve.

I will change my hierarchy with your suggestions.

Hi Ron,

Thank you very much for the reply. I am using the date column (datetime data type) to connect my dimension to the measure.

I have attached the document that...

Thank you very much for helping me with this. I was able to solve the issue using an update statement.

I am trying to map the documenttype to documentno in the source table if the type is "CREDIT".

I don't know which functionality in SSIS I can use to...