Explain in Detail about Measure Objects? and what is the
use of it? How to create it?
Answers were Sorted based on User's Feedback
Answer / janardhan
Measure objects retrieve numeric data, or data that is the
result of calculations on data in the database.
For example: No. of students in the Students Universe.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / nareshkumar
Measure Object convey numeric information which is used to
quantify a dimension object. A measure object returns
numeric information.
You can create a measure object by using aggregate
functions such as,
1)Sum
2)Count
3)Average
4)Minimum
5)Maximum
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / subramanyam
It can be derived fro the Aggregate function.it convay the
numeric information by Dimesion object can be meassured
Is This Answer Correct ? | 0 Yes | 2 No |
what is prompt? Cascading prompt? Syntax
what is the difference between bo and cognos?
what is difference between Rich client web intelligence and Boxir2 web intelligence
what is the difference btween olap and oltp?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
What is the report extension in webi and deski
1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?
what is casual dimension?
what is crystal reports?how to migrate them?
How to delete the duplicate colums in a sql table ?