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

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2610


What are the join problems comes appart from loop,chasm & fan Traps

1557


What is the difference between the public object&schema object?

581


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1629


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1583






in sap bi we have wad, then why we go for sap bo

2779


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1624


How would you format some text using css to be verdana and bold?

675


What is a bo repository?

596


How many universes can be created in a project?

599


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1615


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1589


What would you consider as your biggest achievement and why?

620


How to restrict password to a user while sending a document in .pdf format

1866


Explain about a task that really tested your analytical abilities?

761