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
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
What are slice and dice?
What are query items?
How can you link a query to a data container manually in Report Studio?
What do you understand by the term 'aggregate cache'?
Define the cognos reporting tool?
Tell me about Dnamic and Static Dashboards?
What is main advantage datawarehousing over oracle?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is a Folder?
how to perform back drill through in cognos 8 what is the use of it
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
---------------Describe OLAP Reporting and RDBMS Reporting?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
Can you define report item?