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 |
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
--------------what is MemberCaption?
hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save
how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?
What errors and types of errors you faced in Cognos ReportNet?
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
Can anyone tell me the step by step process how to connect cognos to oracle?
Sales person are there in one company How to do Bursting on this particular requirement?
What is Parametermap?
what are the special features in cognos reportnet?
what are determinants?
4 Answers College School Exams Tests, IBM,
what is report view?