Explain in Detail about Measure Objects? and what is the
use of it? How to create it?

Answer Posted / preetham

Measure objects are meant to define and retrieve the
numeric data. Example : If we want to retrieve the data of
country wise sales revenue. We have to create any measure
object(name it 'Sales') throgh right click in universe pane
> double click the object > define as measure property,
give select statement with facts measure and click OK.

Now, If you run query against country and sales. We will
get data form the report level showing the sales in
numerical data that exist. So Without assigning the measure
object with the select statement of fact measure, we cannot
get sales value.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is xcelsius architecture?

4356


what will be the contents for a functional requirements specifications

2091


Did you face any problems while creating reports? Name? Solutions?

3499


Explain what are the steps to do to use alerts in bo?

841


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1659


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1285


What would you consider as your biggest achievement and why?

820


Can Bo generates the Report from the cubical data Explain?

1853


How to generate the report from excel sheet?

885


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1953


Explain about a task that really tested your analytical abilities?

1035


Explain how to execute the plsql procedure from the report by clicking with mouse?

838


any difficulitis have you phase while creating bo reports and how did u solve it

3201


Explain in detail about type 1?

960


Can you please send me the migration related issues .

1886