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
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 ?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
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??
Explain what sort of existing documents should business analysts refer to when starting on a new project?
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.
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?
Explain what task is 98% of the required work of a business analyst?
what are the tables used in health care domain project and columns used in report?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what are the measure objects?
how to prepare the documentation in business objects and where to get the requirement?
How many universes can be created in a project?
What is top business?
(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.
What we need to discuss with designer before starting the universe designing.