how can u find the granularity in fact table

Answer Posted / swarupa

level of granularity defines the extent of detail. As an example, let us look at geographical level of granularity. We may analyze data at the levels of COUNTRY, REGION, TERRITORY, CITY and STREET. In this case, we say the highest level of granularity is STREET

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

5969


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1535


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3917


Explain what sort of existing documents should business analysts refer to when starting on a new project?

601


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1885






What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1557


Explain what task is 98% of the required work of a business analyst?

598


what are the tables used in health care domain project and columns used in report?

4035


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1689


Explain what are the measure objects?

547


how to prepare the documentation in business objects and where to get the requirement?

1782


How many universes can be created in a project?

597


What is top business?

567


(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.

994


What we need to discuss with designer before starting the universe designing.

1816