Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 10572 Views
- Satyam, I also Faced
- E-Mail Answers
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 a Conformed Dimension?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,
How to a create header dynamically in a crosstab report in cognos 8.1?
what is drill down and slicing and dicing what are the difference between them?
8. Can you use calculations in report headers and footers? How?
How can I schedule reports in cognos?
Where in report Studio's property pane can I find NoDataHandler?
what is the difference between cognos8 fm and cognos reportnet fm?
What are the advantages of using cognos sql?
What is meant by report studio short cut?
What DB View and Bus View?
Teradata 
