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 |
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
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?
what is stitched query???
what are diff b/w cognos and business objects
what is the use of layout component reference
Can you explain model durability?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..
What is a Pivot?
How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.
cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer