This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Essbase Studio, ASO Multiple Hierarchies, and Recursive Dimensions

May 23 2012 at 11:40 AM
No score for this post

David Welden 
from IP address 167.219.0.140

My first ASO cube, so bear with me please. And I have read the fine but sparse manual which does not directly address my issue as far as I can see. I see it discussed in Glenn's fine book also, but not specifically in terms of how to satisfy ASO requirements. Perhaps recursive tables are not the norm?

I am building a dimension that has multiple alternate shared member rollups. I have directed studio to build this dimension as Multiple-hierarchy enabled.

The table for this dimension is in parent/child form and includes both the stored and the shared (dynamic) rollups. Studio is failing to build the outline as it apparently wants to build all of the hierarchies as stored. I saw the hint about properties on Generation 2 members. I tried changing it from Store to Dynamic but that did not help.

Am I going to have to separate the stored hierarchy and the share hierarchies into 2 different tables or 2 different dimensions in Studio to get this to build?

CALVIN: You know, Hobbes, some days even my lucky rocketship underpants don’t help.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. EIS - SK on May 23, 11:44 AM
  2.  
  3. Re: Essbase Studio, ASO Multiple Hierarchies, and Recursive Dimensions - GlennS on May 23, 12:17 PM
    1. Re: Essbase Studio, ASO Multiple Hierarchies, and Recursive Dimensions - David Welden on May 23, 1:53 PM
      1. Re: Essbase Studio, ASO Multiple Hierarchies, and Recursive Dimensions - Glenns on May 24, 1:36 PM
        1. Re: Essbase Studio, ASO Multiple Hierarchies, and Recursive Dimensions - David Welden on May 25, 10:09 AM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.