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 the use of Excel files in Cognos8?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
What are the ways to import data into catalog?
2. What functional area you worked on.
what is the difference between native sql and cognos sql?
how to hide a particular pages at time if you get blank pages
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?
Main Differnce between Cognos7 and Cognos8
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What are shortcuts? Where it can be used? What are the advantages?
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.
What you mean by drill across and what is the difference between drill through, drill across?