Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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
Good practises:
1. we can incrementally update the cube.
2.check the cube status periodically the test cube with a small amount of, 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

Can you define framework manager?

0 Answers  

How to Create users in cognos Access Manager from 1) front end 2) back end

1 Answers   TCS,

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,

suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,

How can I change reports to another package???

3 Answers   IBM,

what is the difference between list sequel and cross tab sequel?

2 Answers  

What is the difference between a cascading report and drill through the report?

0 Answers  

How to pass multiple values from picklist prompt to sub report filter?

2 Answers   IBM, Infosys,

can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  

Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?

7 Answers   Blue Cross Blue Shield Association, TCS,

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

0 Answers   TCS,

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

0 Answers