how u create cubes in ur project
Answers were Sorted based on User's Feedback
Answer / rajdeep chatterjee
Cubes can be built by running the powerplay transformer
model (.mdl file). We need to define the dimensions and
measures in the transformer model, need to mention the
sources (.iqd file, .xls file etc.) and need to provide the
cube name and path. Then we can build it manually as well
as it can be built using any third party scheduling tools.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / pradeep nagireddy
for cube creation following are the importent steps
1.Prepare a data source for cognos transformer
2.Prepare dimensions in dimension map
3.prepare measures in measures pane
4.set propertys to dimensions
5.set data formate for measures
6.create a new cube in power cube pane
7.set propertys to that cube
8.generate categorys and compare them with datasource
9.publish cube in cognos server
| Is This Answer Correct ? | 2 Yes | 1 No |
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What are various types of gateways in cognos?
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......
What is dtm?
Can any one tell me cognos training class in chennai? thanks in advance...
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is the size of the cube?
-------------Diff b/w Union and Unionall?
fiscal year means what???
What are the differences between Cognos 8 and Cognos 7.x version?