Hello,
I'm learning Advisor and TM1 in Cognos Express
and I'm wondering what are the main differences between these applications?
I created a cube with Data Advisor and filled it with data.
This cube can be used from both of the applications.
I don't see any big difference in the usage of Advisor and TM1.
What are the differences in their purposes/functions?
I can use the same cubes from both of them, I can drill and analyse with both of them,
I can use what-if analyses with both of them.... The same functions...
And what about xcelerator? Is it more advanced than Data Advisor?
Thanks and Regards,
Stancho
Names are confusing here.
Advisor is Executive Viewer. This is a good looking, fast frontend for OLAP data, in this case for the TM1 data in CXMD. (Full fat EV will talk to other OLAP sources.)
Excelerator Web is TM1 Web. This can be used in a dice and slice way and yes, in that case fits a very similar niche to Advisor, but somewhat slower and less good looking. It can also use Websheets, which are Excel reports linked to TM1. This gives you more control over layout etc, but more limited dice and slice.
The Excelerator Excel addin is TM1 Perspectives. Most experienced TM1 users stick to using that, as the web clients are (as web clients tend to be) slower and less flexible than Excel. It also comes as Architect which is identical in function but can't slice to Excel.
Data Advisor is a rather limited tool to create and populate TM1 cubes from external data - IBM's attempt to beat Qlikview. Since it rebuilds the cubes and loaders each time it is used it's not much use for real work.
Reporter is a cutdown version of the Cognos 8 reporting engine. It can talk to TM1 and to external relational warehouse type data.
HTH