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 |
What is Normalization?
What is model filter and query filter?
How can I schedule reports in cognos?
can you apply grouping on crosstab?
what are summary filters? grouped filters?
What is the use of content store in cognos?
Can you define fan trap?
what is prompt variable
what is cube size?
can you tell me what are the dimension tables are used in project
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer