Hello,
I use SQL server 2005 analysis services. I created a simple view. There are
two tables with relation between them. One contains time information and
second transaction details. I designed time dimension with three levels:
year, month, date. And with this dimension I created cube. Cube has two
measures with sum “aggregatefunction”. When I browse the cube at day level
everything is ok. I each day has different and proper value. But each month
and year display the same total sum of all days! But each month should
contain sum of all days for this month and each year should display sum of
all moths for this year.
I tried to set option “MembersWithData” for year and month to
“NonLeafDataHidden”, but without any visible effect. I guess that there’s
somewhere simple option to set for proper display, but I can’t find it. Could
someone help?
Thank you
Tomasz