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

Modeling Assistance

Started by OmarSultan, 30 Aug 2019 04:12:15 AM

Previous topic - Next topic

OmarSultan

Hi All, i have a bit of a problem trying to model part of the framework model and i was wondering if anyone can help:

Tables:
Text Fact Table: This table contains the textID, date ID , user ID , tag id, groupID. Because the Text can appear in more than 1 group or 1 fact it can show up in multiple rows
Text Dimension: Contains a bunch of attributes , textID , actual text (All the attributes are unique per text id)

What I am trying to do is generate a list on a dashboard with Text , Date while being able to filter by Tag and Group.

What is currently happening is that Cognos is generating a query that is basically select text , date from fact inner join dimensions group by text, date where (filtering conditions on group and tag) ... this is very slow and ends up grouping large text fields.\

What i am trying to achieve is something like having the query group by the textID first and then join on the dimensions.