Interested to Buy Any Domain ? << Click Here >> for more details...
How to crate cubes in transformer ?
- 3 Answers
- 9730 Views
- I also Faced
- E-Mail Answers
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 |
Mention the difference between ‘macros’ and ‘prompt’?
What are the different types of OLAP. Which one is Cognos Powercube?
Wt is the Diff between Business Key & member caption?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
How to create a cube in Transformer? What is the process? Please mention process thank u
what is an associated query?
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
What are cognos connection initial page components?
can any one explain about blue prints&performance tuning in cognos?
Can you define a catalog and types of catalogs in cognos?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?
Teradata 
