Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Number of iqd's in one model 1
- Thread starter RKNLK
- Start date
-
1
- #2
{on the basis that you are referring to PowerPlay Transformer}
Yes.
Right-click in the data source window and choose "Insert Data Source"
Usually to bring in label data and reduce cube size, but also to bring in measures from other sources. For example, in a sales model, you might have a sales iqd with customer account number. A separate iqd for customers will allow you to label customer account number with the customer name or perhaps to allocate for customer type. An example of multiple measure sources would be adding a budget iqd to a sales model to display both sales and budget and determine variance.
You may find the documentation supplied with Cognos to be of use here (all pdfs in the documentation folder of the install) - there are a couple of chapters on practical use of the application that cannot realistically be covered in a thread like this.
The skill in using Transformer comes from considering the logical connection between data to provide what the report users need and what they didn't know they needed, but benefit from. That makes the positive ROI!
soi la, soi carré
Yes.
Right-click in the data source window and choose "Insert Data Source"
Usually to bring in label data and reduce cube size, but also to bring in measures from other sources. For example, in a sales model, you might have a sales iqd with customer account number. A separate iqd for customers will allow you to label customer account number with the customer name or perhaps to allocate for customer type. An example of multiple measure sources would be adding a budget iqd to a sales model to display both sales and budget and determine variance.
You may find the documentation supplied with Cognos to be of use here (all pdfs in the documentation folder of the install) - there are a couple of chapters on practical use of the application that cannot realistically be covered in a thread like this.
The skill in using Transformer comes from considering the logical connection between data to provide what the report users need and what they didn't know they needed, but benefit from. That makes the positive ROI!
soi la, soi carré
- Status
Similar threads
- Locked
- Question