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 |
Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1
What is the definition of derived table ?
i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.