SSAS CUBE Grand Totals Wrong

• d_gomes2

  SSC-Addicted

  Points: 406

  More actions

  September 26, 2018 at 8:39 am

  #408551

  Hi All,

  I am facing a problem where I got Stuck and I cannot see a way to solve.

  So basic I have a small environment 2 currency and for that I use a Fact Rate table with Dates between USD and EURO to give me my sales in EUROS. With this I am able to see the sales amount in USD and EURO.

  My rate fact Tables have the relations to the Sales dates only what is working fine.

  All the tests I am doing as convert the USD Amount  with the EURO rate are fine, take in consideration I have a couple of rates per day. My big issues is when I use the excel with a Pivot table the Grand Total are wrong but if I sum all the Lines the values are Correct, so what I analyze and I check it is the Grand Total appears that is using only the Last Rate and ignore all the previous ones.

  Any suggestion.

  Thank you