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 |
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What are the difference between merge,auto merge and extended merge ?
Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks
How we can add a comment in universe...?
what is stacked chart , Bar chart, Column chart?
What is slicing and dicing in business objects?
What is security level in BO ?
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
How to resolve the partial result error in the report
Is it necessary to give joins to the aggrigate tables in the universe?
Can Bo generates the Report from the cubical data Explain?
plz tell me about BOmain key in detail?