Interested to Buy Any Domain ? << Click Here >> for more details...
How can we create regular dimensions & measure dimensions?
- 2 Answers
- 5989 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
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 ?
What are the components of the report studio?
i have one file i saved in csv how can i take these file into framework manager
What are the two types of framework manager?
What do you mean by query studio?
What is the use of Cognos scenario?
Explain the characteristics of cognos?
How is cognos model organization works?
What is a dimension?
How to select multiple values from type-in prompt?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Define report item?
What is difference between page break and section report?
how to connect datamarts
how can you get the errors in job? when loops are araised we get error?
