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
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 |
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 |
What is catalog and types of catalogs in cagonos and which is better?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
can reportnet supports cubes???
Define the cognos reporting tool?
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
what is cube size?
What is content Manager?
What is main advantage datawarehousing over oracle?
Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com
8. Can you use calculations in report headers and footers? How?
Which lifecycle we will use for reporting?
2.How do you drill through report from Report Studio to Analysis studio?