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
U r project in which stage in implementation?
what are the day to day activities of BO administrator ?
Explain the difference between detect alias and detect context?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
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!!!
(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.
How many universes can be created in a project?
In banking domain how many Fact tables,Dimension table are present?
How would you format some text using css to be verdana and bold?
Is there any other repository domains rather than universe, security, document?
Explain about alerts in bos, under what situation we need to use alerts?
What three things do you consider to be the most important factors for a manager?
Did you face any problems while creating reports? Name? Solutions?
What is object stores?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?