Thanks John thanks for the response can you please confirm, if there's no way we can do the same in Essbase Studio. Just want to make if i am missing out any probability.
Edited by: saleem12 on Dec 10, 2012 4:36 AM
John is correct; you cannot create calc scripts in Essbase Studio.
You can create member formulas in Essbase Studio, but calc scripts are meant to be created in EAS. Studio is for building outlines and loading data.
Thanks John /Dave
we still have a formula tab in the Essbase properties of Studio. Can you please let me know how this tab is helpful.
For an ASO cube can we use this formula tab to write functions or measure calculations as we do in EAS.
Formula tab does say about Calc scripts to be carried on Dynamic hierarchies, i was just curious to use this but never succeed.
Edited by: saleem12 on Dec 10, 2012 5:30 AM
The formula tab allows you to create formulas on specific members within the outline not calc scripts. For the Formula tab to be helpful it is really used on user defined members of a hierarchy (like a scenario varaince) or from an external source associated with specific members.