How to crate cubes in transformer ?
Answers were Sorted based on User's Feedback
Answer / esaivani
1.Analyze user reruirements
2.Determine the source data
3.Build the model and define source data
4.Organise the dimensions,levels,categories,measurses
5.Refine the model
6.create the required cube and consider cube
groups;location where to sstore cube
7.give access privileges for each user
8.Deliver the cube based on user located
9.Distributed the cubes via vss or any other resources
10.give the production support
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rupanjali
1)Analyse all the tables ,columns & joins required for ur
Cubes.
2)in Impromtu drag all the tables,columns .abd give their
join.and form the catalog.If any loops then resolve the
loop.
3)Then generate a impromtu report by taking all the catalog
columns.and save this as .iqd extension.
4)This .iqd file will be the input for our cubes.
5)Then open this .iqd file in tranformer.where you will
create heirarchy for dimension and define the measures.
6)Save it as .pyi files.
7)Run the .pyi files.
8)When the cube is generated save it as .mdc format.
9)This is the cubes.
10)You can open the .mdc file to create your cube report
(multi dimensional) in transformer
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / surendra kumar
hi
cube can be created by using different data sources.
data sources: iqd, tex file ---
cube creation by using iqd data sources.
1)these iqd sources are coming form immpromptu
| Is This Answer Correct ? | 0 Yes | 1 No |
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
Can you define a query subject?
What is the use of Generated Prompt? Where is it used in realtime project?
What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?
1 Answers Cognizant, Niteo, SacSoft,
What is set to be cardinality?
hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........
how u provide security to reports??how u provide security to packages ?
difference between drill through and master detail report?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
can we insert list report in corsstab report?
What is meant by Reportstudio shortcut?
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