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

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

0 Answers  


17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

3 Answers   TCS,


What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.

1 Answers  


advantages of detailed filter??? and summarized filter???

4 Answers   iFlex,


How can you link a query to a data container manually in Report Studio?

0 Answers  


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

0 Answers  


How can I schedule reports in cognos?

0 Answers  


How can we convert imr report into Impromptu web report?

3 Answers  


When You Import data into catalog You have complex columns names. How do you change the Name of those columns?

2 Answers  


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

0 Answers  


1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  


what is Cognos Visualizer and Cognos Scripting?

3 Answers  


Categories