Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / varma
dimension are descriptive information. for example customer
name,address. where as regular dimensions are used to create
the hierarchies in dimensions. for example let us take
product dimension.
u can create hierarchies in product dimension using regular
dimension. u can create hierarchies as product
number,product name, product line code,product description.
the regular dimensions are used in analysis studio for drill
down and drill up methods
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between set functions and filter function in dimensional data?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
Can you define cube?
What do you understand by the cognos?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
how to create measures and dimensions?
what is the role of cognos comsultant?what actually it means?pls reply
What are the components of the report studio?
can we insert all types of charts in a list report? what r the realtime prompts?
What is difference between informatica power mart and power center?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What are shortcuts? Where it can be used? What are the advantages?
What is Bitmap Index?
