Tutorial problem - please help
Guys,
I am working through the tutorial. Although I discovered this problem in lesson 7 it has nothing to do with the KPIs. All this relates to Sales Amount Quota.
If I browse with no time filtering, I get $109,226,500 which agrees with the tutorial. If I make Fiscal Year a row dimension, I see 2004 has $43,240,000 which agrees with the tutorial. If I use fiscal year as a filter (restricting to 2004) as well as having it as a row dimension, the 2004 figure shows correctly and there is a grand total of $109,226,500. If I then remove the row dimension (leaving the filter) the $109,226,500 remains but the 2004 figure disappears. This does not agree with the tutorial.
As an experiement I then used Calendar quarter as a filter selecting the quarters that make up the 2004 fiscal year. Putting fiscal year on the row showed the c orrect value for 2004 but also showed a total 1.3125 times greater than the only displayed row.
Next I tried loading the prebuilt lesson 7 cube and browsing that. I made no changes to that cube at all, but it also failed to match the tutorial values. In fact it seemed to be in worse shape than my cube. It showed a value of $95,714,000 for each year except for 2005 which was 1.25 times greater.
I am pulling my hair out. Can someone please help me with this. If I can't get the tutorial working how will I ever build a real application?
Thanks
Cliff
