This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
  << Previous Topic | Next Topic >>Return to Index  

Essbase Filters issue with shared hierarchy

February 20 2013 at 1:06 PM
No score for this post
Deepak Shakya 
from IP address 38.106.206.102

Hi,

I am required to apply filters on hierarchies with all shared members. Problem is after the first retrieval down to the level of shared members (level0), the data values dissappears for the subsequent retrievals in smart view. In the below example all the children of "EOP-Cassidy Turley" are level0 shared members and same is applicable to " ...by Company" node.

----------------------------------------Accounts Reporting Scenario Year
----------------------------------------Period
----------EOP-Cassidy Turlely-----------333333333.3 ** contains level0 shared members as children
-----Fee Management---------------------#No Access
----------EOP-Cassidy Turley by Company-333333333.3 ** contains level0 shared members as children
-----Fee Management by Company----------#No Access
Business Units--------------------------#No Access

As long as I do not drill further down to level0 of the 2 nodes shown above with values, everything works fine. I do see the data once when I dril down further. But values dissappear after that one retrieval and also the level0 members list is not recognized as members in smartview but just as text cells.

I am applying metaread filter for the 2 nodes. Can we not use metaread filter on shared hierarchies? Please share your experience. Thank You!

Best Regards,
Deepak Shakya


 
Scoring disabled. You must be logged in to score posts.Respond to this message   
AuthorReply
Deepak Shakya

38.106.206.102

Re: Essbase Filters issue with shared hierarchy

No score for this post
February 20 2013, 2:09 PM 

Anyone who can throw some light on this issue please?

Thanks,
Deepak

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

38.106.206.102

Re: Essbase Filters issue with shared hierarchy

No score for this post
February 21 2013, 12:07 PM 

Would greatly appreciate if some one can shed some light on this! I have been doing some digging online but nothing much I could find related to this issue.

Thanks!

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

38.106.206.102

Fixed

No score for this post
February 22 2013, 11:12 AM 

This issue was definitely because of applying the filters on the shared member hierarchies. I applied the filters on the original members and the report works fine. Just the way I expected.

However, as in the original hierarchy the members are all scattered, now I have to hard code the members in my filters. I believe thats acceptable in this case.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
 
  << Previous Topic | Next Topic >>Return to Index  

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.