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
Difference between zabo and webi?
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?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
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.
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain how to execute the plsql procedure from the report by clicking with mouse?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain what are the measure objects?
Explain about a tricky situation for which you found a very simple solution?
what is xcelsius architecture?
Explain what three things do you consider to be the most important factors for a manager?
When to use local filter and when to use global filter?
any difficulitis have you phase while creating bo reports and how did u solve it
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
What is object stores?