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 is log in cognos?

666


----------------Describe DWH Architecture?

1654


1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

1772


how to perform back drill through in cognos 8 what is the use of it

2035


How to deploy from one server to another server?

2021






how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

594


What is difference between primary key and unique key constraints?

568


What is the model filter?

600


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

1901


What is the difference between regular dimension and derminant?

1692


How security is concerned with Reportnet? Explain its implementing steps.

1614


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1553


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1549


What is the information present in the cognos configuration file?

541


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

1288