This content has been marked as final. Show 9 replies
Thanks for your reply. This is only a Essbase Application, user majorly using Excel addin for data input. Yes,I am using SSAUDIT, this is generating ATX and ALG files.
But this is not giving a information like who has exactly done the input for a particular intersection.
This is Essbase Version 184.108.40.206.0. Does Transaction Logging resolves this issue? Can you tell me the purpose of it and how to make use of it please?
Thanks John. I learnt this command won't help to find by whom and when the data has been modified.
Is there any utility or third party tool you aware to find the list of users and the data intersections modifed by them?
Do you suggest any other alternatives to achieve this?
Thanks again for your help on this.
I noticed one weired thing when adding below statments in the essbase.cfg file. I got "Error: 1013350 Failed to load database" when adding both these lines.
To confirmed it, I commented them, restarted the Essbase service and then the application started with out any issues.
::TRANSACTIONLOGLOCATION /Hyperion/trlog NATIVE ENABLE
::TRANSACTIONLOGLOCATION app db /Hyperion/trlog NATIVE ENABLE
Note: I tried with the different combinations like enabled both, enabled one statement at a time. But still the applicatios/application were not responding.
Can you please guide how to overcome this issue.
You may want to look at our Dodeca product which is a replacement for the Excel add-ins. It provides a managed user environment that looks and acts like Excel. It uses Excel templates for its retrieve/send operations but maintains a relational log of all data changes. There is a good introductory video online at http://www.appliedolap.com/dodeca/videos.
Applied OLAP, Inc