Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 8653 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhi
We can add new dimension by including it in data source file
(csv, iqd etc) and clicking on the modify column in the
dimnension it will reflect there and then the cube build
can be done.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vij
To add new Dimension in Cube u need to open that particular
created Model i.e. .pyi file
and then u can add ur new dimension in dimension Pane and
then recreate ur already existing CUBE.
Hope it will help u :)
thnx,
vij
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / sathish kumar
after cube has been populated,it can not add new dimension
at all...
Thanks
Sathish
| Is This Answer Correct ? | 0 Yes | 2 No |
Explain the different types of views used in cognos.
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
How to connect three fact tables?
11 Answers L&T, TCS,
What is a Query Subject?
What is Index?
What is the difference between filter & Condition?
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
What is difference between informatica power mart and power center?
what are burst options you have?
What is a scope? can you tell me one example for scope?
Teradata 
