I’m very happy with the excel add in (Analyzer). However, i just miss one feature here.
When you have a lot cells which need to be updated, it’s difficult to see the status of the update.
Is there a possibility to add a status bar in your excel screen showing a % completed.
We are heavy users of Analyzer to pull data from and push data to Prophix. The way we tell status of the report update is the little green ‘refresh icon’ light up in each of the cells with formulas while running and when they stop blinking, the report has completed.
I use this to enter our projection into Prophix. I have been very please with the time savings it provides. I would like to figure out other ways to use the feature as I find the ease of use to be beneficial.
We recently started using utilizing Prophix Analyzer. Our biggest file has about 10 tabs that have to be updated. It would be nice to have a notification of some kind when I do a refresh all when it is completed.
Analyzer IS saving us quite a bit of time to update those 10 tabs (previously was being done via copy and paste!). So i am liking this change and starting to think of other ways to implement using it.
I do wish you could have more than one data view per tab though.
We have issues with Analyzer. Some users will corrupt links and others will not. Also, no one is able to tell me how to change analyzer formulas when you use an alternate hierarchy