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 |
Interval Prompt's Usage? Example for usage in Project
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
what is symmetric key?where do u use this?
What is Portal Tab?
--------------what is MemberCaption?
what is hints in cognos and where we use it.
what is the difference between aggregation and roll up aggregation?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
What is Tool Tip? and how to create in report studio?
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
What are the advantages of cognos?
WHAT ARE THE TYPES OF LIST REPORTS?