1.Can we create a cube in a Transformer from multiple
IQD's ?if so, how?
2.Also , explain some of the best practises used ,while
creating a cube in powerplay transformer.

Answer Posted / guest

yes we can create cube from multiple iqd's , we have to
first import the primary datasource which contains most of
the structural data item required for the cube creation,
and then other sources,by inserting the data source
separately.
Good practises:
1. we can incrementally update the cube.
2.check the cube status periodically
3.run the test cube with a small amount of data.eg., if you
have 1000 records , we can assign 300 records from each
data source and perform a sample test cube.
4.we can do partition, to improve the runtime performance.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

WHAT ARE THE DISTNICT VARIABLES?

1726


What is the use of Cognos scenario?

695


What are all the types of hierarchies?

650


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

538


What is the use of report studio?

573






------------- How to identify the Revenue Column in Report?

1794


What do you understand by the term 'model durability'?

544


-------------How you design DWH?

1870


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1261


New coloums are added in database, then how you know in report level

1130


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1579


What are all the components of Report Studio?

626


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

1601


whats the difference between previous version of cognos and cognos 8 BI?

4709


Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1610