If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

One Report with Cube Data and SQL Data?

Started by froodyo, 31 May 2019 01:02:12 PM

Previous topic - Next topic

froodyo

This seems like a silly questions, because I believe it is not possible, but I just need a solid answer to put my mind at ease.

I am trying to figure out if it is possible to create a prompt using SQL data to filter a report the is created from a TM1 cube. I am looking to filter on an attribute that is already pulled from this database and placed into a dimension within the cube I am reporting on. Is this a possibility?

Thank you,
Grady

MFGF

Quote from: froodyo on 31 May 2019 01:02:12 PM
This seems like a silly questions, because I believe it is not possible, but I just need a solid answer to put my mind at ease.

I am trying to figure out if it is possible to create a prompt using SQL data to filter a report the is created from a TM1 cube. I am looking to filter on an attribute that is already pulled from this database and placed into a dimension within the cube I am reporting on. Is this a possibility?

Thank you,
Grady

Hi,

Theoretically, yes, it's possible. In practice, you would need a package that includes both the relational content and the TM1 cube. The trick will be in deriving a dimensional expression that uses the relational value(s) to deliver the members you require. You haven't specified whether this is a slicer or if it is a prompt that drives the members retrieved in a report container, but I'm thinking you'll need to use a filter function based on the attribute in question, eg

filter([your TM1 dimension or level], [your TM1 attribute] = ?your prompt parameter?)

This wouldn't necessarily perform optimally, though.

An alternative, if you know the structure of your MUN, might be to use a macro with a prompt function to construct the MUN based on your prompt parameter.

Sadly the forum won't allow me to post an expression with macro hash symbols in it :)

Cheers!

MF.
Meep!

froodyo

Let me back up a step, since it's really not an issue with the actual filtering, it is more of an issue of the prompt page taking forever to load when it is loading attribute data for the prompt.

My hope was, since the attribute is coming from our ERP database, is that I could make the prompt for the query pull from the SQL database and then use that value to filter the dimensional report.

Also, you have to forgive any ignorance and lack of knowledge, I am new to the dimensional reporting world.

Thank you,
Grady