How to see if tm1 view was used when report is run?

abcuser · Post by **abcuser** » Thu Jan 16, 2014 2:01 pm

Hi,
using Cognos BI 10.2.1 accessing Cognos TM1 10.1.1 cube both on the same Windows 2008 RC2 server.

For one cube I am making performance tests I created some views in TM1. I also configured tm1top to see the time reports are executed. Is there any way to see if Cognos BI is using particular TM1 view? If possible I would like to see view name to see if my TM1 view is correctly created.

Thanks

lotsaram · Post by **lotsaram** » Thu Jan 16, 2014 2:11 pm

abcuser wrote:Is there any way to see if Cognos BI is using particular TM1 view? If possible I would like to see view name to see if my TM1 view is correctly created.

No. Cognos BI doesn't use TM1 views as data source for starters, the data source is a Framework Manager package. In TM1Top you may be able to see a function call CubeCellValueGet or ViewArrayConstruct but I'm unaware of any way to identify the cube via top.

However in a controlled test you should be able to match the user thread to a particular report and from the report you know which package and therefore which cube is being used.

qml · Post by **qml** » Thu Jan 16, 2014 2:25 pm

lotsaram wrote:... you know which package and therefore which cube is being used.

This is strictly speaking not always true as it is possible to have a FM package reference more than 1 cube.

If your package is set to use Compatible Query Mode then all the queries will be MDX-based and it should be quite easy to capture them in the TM1 server log by turning MDX debug on. In the case of Dynamic Query Mode it's not as easy, because most of the data exchange will go through the API and I personally haven't found an easy way to capture/audit such queries.

ram123 · Post by **ram123** » Fri Jan 17, 2014 7:04 am

lotsaram wrote:... Cognos BI doesn't use TM1 views as data source for starters, the data source is a Framework Manager package.

Was shot with a similar question yesterday..
Is it possible to integrate TM1 to BI (or vice versa) without the help of Framework Manager?

I strongly believe NO. Atleast, BI to TM1 is NOT POSSIBLE without the use of FM coz' thats where we create the package and call the package in TM1 (using Pkg Connector).

But i'm just wondering if data in TM1 can be populated in BI without FM. As far as I'm aware, it is not possible as we need to connect to the Data Source (TM1 cube) in the Metadata wizard (using FM).. right? Plz correct me if i'm wrong here.

Any other option available?

For example, connecting to the Contributor directly using Cognos Configuration etc.. ? Or pull data from TM1 Web??

declanr · Post by **declanr** » Fri Jan 17, 2014 7:42 am

ram123 wrote: But i'm just wondering if data in TM1 can be populated in BI without FM. As far as I'm aware, it is not possible as we need to connect to the Data Source (TM1 cube) in the Metadata wizard (using FM).. right? Plz correct me if i'm wrong here.

Any other option available? For example, connecting to the Contributor directly using Cognos Configuration etc.. ? Or pull data from TM1 Web??

Both TM1 and BI can connect to a SQL database (or other DBs) so you could also push data from tm1 to a table then connect to that from BI, as to why you'd want to it i'm not sure.

ram123 · Post by **ram123** » Fri Jan 17, 2014 8:53 am

declanr wrote:
ram123 wrote: But i'm just wondering if data in TM1 can be populated in BI without FM. As far as I'm aware, it is not possible as we need to connect to the Data Source (TM1 cube) in the Metadata wizard (using FM).. right? Plz correct me if i'm wrong here.

Any other option available? For example, connecting to the Contributor directly using Cognos Configuration etc.. ? Or pull data from TM1 Web??

Both TM1 and BI can connect to a SQL database (or other DBs) so you could also push data from tm1 to a table then connect to that from BI, as to why you'd want to it i'm not sure.

No, we wouldn't be connecting to other DBs when integrating from TM1 - BI (or vice versa). Simple reason is, we would like to want the same data to be represented as it is when getting populated in other tool (BI for example). This has been a pretty common requirement we faced where the client is using both TM1 and BI.
He wants the dimensions/metadata etc. to be almost similar when displaying in the BI report studio (from a TM1 cube view). So, I would like to pull/push data directly from TM1 to BI without any other source (like DB tables) in between.
So, when the fresh data gets updated in the TM1 cube view, it will almost immediately should get reflected in the BI (Report/Analysis studio).

Michel Zijlema · Post by **Michel Zijlema** » Fri Jan 17, 2014 12:29 pm

ram123 wrote:Is it possible to integrate TM1 to BI (or vice versa) without the help of Framework Manager?

I strongly believe NO. Atleast, BI to TM1 is NOT POSSIBLE without the use of FM

Workspace is a Cognos BI component in which you can incorporate TM1 Web reports. This is a read-write link to TM1 in Cognos BI, without the use of FM.

Michel

TM1 Forum

How to see if tm1 view was used when report is run?

How to see if tm1 view was used when report is run?

Re: How to see if tm1 view was used when report is run?

Re: How to see if tm1 view was used when report is run?

Re: How to see if tm1 view was used when report is run?

Re: How to see if tm1 view was used when report is run?

Re: How to see if tm1 view was used when report is run?

Re: How to see if tm1 view was used when report is run?