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

I don't think possible

June 15 2017 at 7:47 PM
No score for this post
from IP address

Response to ASO Dimension build question

1st - You can't edit and replace in dim build. At least I have never seen that.
2nd - You will need to put in Level or Generation or Parent/Child format do build a dim.

I would:

1 - Extract the outline via outline extractor from AppliedOLAP with pipe delims.
2 - Open in Excel
3 - Use Excel to edit and replace via formula
4 - Save new revised Excel file in desired format with appropriate delims.
5 - Build a dim build rule and build the revised dimension.

Do that on another cube to validate and test and then copy it over to the real cube.

BTW - You never mentioned if the data in the cube needs retained or if it has data. If it has data then that's a whole different issue that needs dealt with. Maybe export the data and build a data load rule with edit and replace to do the mappings. Not sure how many accounts and rows of data you are talking about.

Good luck!!!

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

  1. Re: I don't think possible - TimG on Jun 15, 2017, 8:03 PM
    1. Re: I don't think possible - AU on Jun 16, 2017, 9:38 AM

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.