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 |
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
How to create multilingual reorts?
Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
explain how to create powerplay reports?
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
advantages of cascade prompt ???
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What is set to be cardinality?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
What are the different ways of adding data in Transformer?
What is drill down and slicing and dicing whats the difference between them?
What are the themes in a data warehouse?