Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aggregations storage & Custom rollup

Status
Not open for further replies.
MrAbeille

MrAbeille

Programmer
Apr 2, 2003
1
FR
Hello,

I designed a cube with several dimension:
- 5 dimensions with 1 level and 5 members
- 1 Product dimension with 7 levels and 6000 members at the bottom level

I defined custom rollup formula at each level of the Product dimension to calculate average values (formula: Sum([Product].CurrentMember.Children) / Count([Product].CurrentMember.Children,INCLUDEEMPTY)).

When I design the partition, I have only 12 aggregations!!
That means all my custom rollup formula are not stored in the partition.

Is there a way to force storing aggregations based on custom rollup formula?

Regards,
Jerome
 
Status
Not open for further replies.

Similar threads

ianclarke
  • Locked
  • Question
Unknown Member & Null Processing
Replies
0
Views
89
ianclarke
ianclarke
snakeyes2620
  • Locked
  • Question
Customer Cube Dev
Replies
1
Views
53
johnherman
johnherman
cs2009
  • Locked
  • Question
SSAS & SSRS; Excel 2007 Report Action with Parameter 1
Replies
2
Views
26
cs2009
cs2009
eo
  • Locked
  • Question
MDX & distinct count & date ranges
Replies
3
Views
94
eo
eo
dean12
  • Locked
  • Question
0 aggregations designed - Analysis Services 2005
Replies
6
Views
59
dean12
dean12

Part and Inventory Search

Sponsor

Back
Top