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
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.
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