-
1. Re: Adding commentary in ASO Cube and aggregating it to TOP Level
GlennS_3 Apr 27, 2015 3:07 PM (in response to Anubhav)ASO cubs (created by Planning or independently don't 'support commentary let alone merged commentary .You could possibly do what you need by creating a smart list Planning and passing the value of the list to a text list in the ASO cube. Where you want the value to be merged since this would be a rollup hav a text list value which is the sum of the smart list values. (note, I've not tried this is it all theoretical)
-
2. Re: Adding commentary in ASO Cube and aggregating it to TOP Level
Celvin Kattookaran Apr 28, 2015 12:24 AM (in response to Anubhav)Apart from what Glenn suggested
Not out of box, you are looking at a JAVA API + SQL based solution here
Here are my thoughts
Either use a Select query and get the Text values and IDs from the tables HSP_CELL_TEXT (or HSP_TEXT_CELL) table
Create a Java API, which can import a TextList in ASO cube, ID is going to be what you get from the table
Load the data to ASO from Planning
Now for the aggregation/concatenation part, you'll have to Add those as again Smart List, This can be done by looking at HSP_CELL_TEXT (or HSP_TEXT_CELL) table, there is an ID associated with each text, get the id associated
So for example Market Risk Deviation is 1 and Standard Output Deivation is 2, then you should add Market Risk Deviation + Standard Output as 3, however you'll have to make sure that there is no entry from Planning for 3
It is complicated
Regards
Celvin Kattookaran
-
3. Re: Adding commentary in ASO Cube and aggregating it to TOP Level
Anubhav Apr 28, 2015 9:13 AM (in response to Celvin Kattookaran)Hi Gleen and Celvin.
@Gleen : thnaks for the reply i guess i need to do some customize solution.
@Celvin: that is good idea to start with. Just one question which comes in my mind is when Report will be Extacted from ASO how those extry will be refeclted as Text in the report.
What me and my collegue was discussing was showing the number from ASO (since they need to be Aggregated) and Showing text from BSO and concatenating it.
Will work on what you have suggested
Best Regards
Anubhav Bisht
-
4. Re: Adding commentary in ASO Cube and aggregating it to TOP Level
Anubhav Apr 29, 2015 4:34 PM (in response to Celvin Kattookaran)Hi Celvin,
I have tried that. what i did is just make a entry (random number) in essbase and make a corresponding text entry in Cell_Value table but when i refresh the corresponding text is not getting reflected across that member.
I believe when we enter text it do goes in the Cell_Value table but when Planning reads it , it need more then only this table.
Working further on this.
Cheers
Anubhav Bisht
-
5. Re: Adding commentary in ASO Cube and aggregating it to TOP Level
Celvin Kattookaran Apr 30, 2015 10:34 PM (in response to Anubhav)Have a look at this http://www.orahyplabs.com/2015/04/move-planning-text-data-to-aso-with.html
I did create this after I gave you the idea
Regards
Celvin Kattookaran
-
6. Re: Adding commentary in ASO Cube and aggregating it to TOP Level
Anubhav May 5, 2015 8:22 AM (in response to Celvin Kattookaran)Hi Celvin,
Thanks for the Marvelous Blog. Loved it.Will use the contents of it to automate the entire process.
Cheers
Anubhav Bisht