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.

Answers were Sorted based on User's Feedback



1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain so..

Answer / 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

1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain so..

Answer / vijaya yadav

yes we can create a cube with multiple IDQ's as data
sources,for this insert data source of tyye Impromptu Query
Definition in Transformer model.
afer creating a cube u can---
1)Partition a cube
2)Update a selected cube by batch file or by macro
3)Apply security to a cube
4)Compress a cube.
5)Publish that cube on Upfront.
6)Use that cube as DataSource in FM in Cognos Series 8

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

when can i use the STAR Schema and SNOWFLAKE Scgena

4 Answers   IBM,


1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?

3 Answers  


Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,


Explain is there any comparison available for cognos reportnet vs crystal reports?

0 Answers  


Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,


Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !

3 Answers  


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

1 Answers   IBM,


how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview

2 Answers   IBM,


if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

3 Answers   ComNet,


What is Lookup ,bridgeing tables where they will use in the Dataware house

2 Answers   IBM,


Hi, How the relations will be exists in DMR models if u have any idea please explain me

2 Answers   Polaris,


What is namespace and what it holds?

7 Answers   IBM,


Categories