I don't think possibleJune 15 2017 at 7:47 PM
No score for this post
from IP address 126.96.36.199
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.
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.
- Re: I don't think possible - TimG on Jun 15, 2017, 8:03 PM
- Re: I don't think possible - AU on Jun 16, 2017, 9:38 AM