How can we create regular dimensions & measure dimensions?
Answers were Sorted based on User's Feedback
Answer / amar
In Framework Manager
Go to Actions Menu--> Create ---> select regular dimension or
measure dimension ( what you want to Create ).
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sunitha g
In framework manager we have to create one layer/view/namespace i.e DMR Namespace
in that we can create 2 type of dim that have regular & measure
regular:goto actions -->regular dimention or else right click on dmr namespace -->goto regular dimention
create hierarchies ,define levels,give the business key * member key options
For example : country ,State,City levels from geographical hirarchy
Measure:Its having only measure values & fact information
need to follow this process, right click on dmr-->goto measure dimention & Just drag & drop the measure what ever you need based on your requirement
Give the scope relationship between both of them
| Is This Answer Correct ? | 1 Yes | 0 No |
6. Which of them will increase the performance?
what is exact catalog size?
In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.
4 Answers Accenture, HCL, IBM,
What is main difference mapplets and mapping?
what is filter?give me one example that you created a report in your project?
difference between drill through and master detail report?
in u r data u having duplicates how to fetch the latest data in our report?
How to a create header dynamically in a crosstab report in cognos 8.1?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
can we join 2 different queries? One has 10 columns and other has 5+ columns?
what is an sid (surrogate key)?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.