Managing External Data and Govenor Settings in Cube Package

[KS]

Hi,

I'm trying to create a report from an existing Cube package and an Excel file with more than 1000 rows. I was able to change the Governor settings for our relational packages in Framework manager so that we can import the Excel file and join it to relational packages. However, I was wondering how to change the Governor settings with a Cube Dimensional model that can only be opened in Transformer.  Does anyone know where the Governor settings are in Transformer or if I can set these settings somewhere else?

Thanks,
Katie

[MFGF]

Hi,

I'm trying to create a report from an existing Cube package and an Excel file with more than 1000 rows. I was able to change the Governor settings for our relational packages in Framework manager so that we can import the Excel file and join it to relational packages. However, I was wondering how to change the Governor settings with a Cube Dimensional model that can only be opened in Transformer.  Does anyone know where the Governor settings are in Transformer or if I can set these settings somewhere else?

Thanks,
Katie

Hi Katie,

If I'm understanding correctly, you're looking for a way to join an Excel spreadsheet to a Cognos Powercube in your package? If so, sadly you're not in luck. Joining is a relational concept and is only possible in relational packages (where the query engine is generating SQL). Packages based on cubes are dimensional, and generate MDX rather than SQL. A relational join is not possible in this paradigm.

Cheers!

MF.

[KS]

Thanks MF.  That make sense.  Too bad! 

[MFGF]

Thanks MF.  That make sense.  Too bad!

The best you can do is to have both sets of data in your package, and in a report use a master/detail to link them together. Remember though that the dimensional data is based on members identified by a Member Unique Name, so you'll likely need to extract the caption to use in the master/detail

Cheers!

MF.

[cognostechie]

Hi,

I'm trying to create a report from an existing Cube package and an Excel file with more than 1000 rows. I was able to change the Governor settings for our relational packages in Framework manager so that we can import the Excel file and join it to relational packages. However, I was wondering how to change the Governor settings with a Cube Dimensional model that can only be opened in Transformer.  Does anyone know where the Governor settings are in Transformer or if I can set these settings somewhere else?

Thanks,
Katie

You can add that Excel file to Transformer as a data source and have that data go inside the cube. You, then , will have only one package with everything in it. The good thing about Transformer is that you don't have to join anything but you can associate data from different sources and all that data goes into one single object (cube) which then makes reporting very easy without causing any performance issue even if the source data was in 10 different databases or excel files. Something Framework Manager cannot do.