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 |
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Can you define cognos decision stream?
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
What are the components of the report studio?
How you drill from powerPLay to Impromptu?Explain all Steps?
Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !
What are the advantages of cognos?
Define olap designer?
How to connect three fact tables?
11 Answers L&T, TCS,