how u create cubes in ur project
- 2 Answers
- 5156 Views
- IBM, I also Faced
- E-Mail Answers
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 |
1. Explain your project.
write a query to display to 10 max record from the employee table?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is cognos connection?
What is meant by Reportstudio shortcut?
what are typees of dimensions
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.
What errors and types of errors you faced in Cognos ReportNet?
What is model?
WHAT STEPS SHOULD BE TAKEN BY A REPORT DEVELOPER TO INTERACT WITH THE CLIENT SERVER?
What is Model Versioning or Versioning in Cognos Framework Manager?
Teradata 
