Follow Our FB Page << CircleMedia.in >> 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
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

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  






Categories