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
What task is 98% of the required work of a business analyst?
how get the grand total in master-detail report?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How to execute the plsql procedure from the report by clicking with mouse?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Can Bo generates the Report from the cubical data Explain?
What is a fantrap in business objects?
What is report template in b.o?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain when to use local filter and when to use global filter?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
explain in detail about type 3?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha