Interested to Buy Any Domain ? << Click Here >> for more details...
How to crate cubes in transformer ?
- 3 Answers
- 9726 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 |
Diff b/w Crossproduct and Outerjoin?
How can you create prompts in framework manager?
how you create security to cubes ?????
what use of surgate key in project
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
how many types of keys are there i.e primary key and foreign key etc..?
How is possible this scenario using in type-in prompt.?
Can you define set to be cardinality?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
what are summary filters? grouped filters?
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.
how to handle multifact?
Teradata 
