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 |
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
How to perform single signon in Cognos by using URL?
How to pass multiple values from picklist prompt to sub report filter?
Explain how data modeling is useful to cognos in daily life?
Can we create a web page where the report directory and the output can be viewed directly across cognos connection?
what are the names of the reports that you prepared?
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
where you can save the report net documentation in our local system?
what is dimention?explain dimentable with example?
Can you define pivot?
hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........
What is the difference between drill down and drill through?
10 Answers DELL, Deloitte, Systime,