how can u find the granularity in fact table



how can u find the granularity in fact table..

Answer / 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

More Business Objects Interview Questions

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

4 Answers   IBM,


What is slicing and dicing in business objects?

4 Answers  


What is a category?

3 Answers  


WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,


what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,






Can any one say me wat does"maintanence of universe" means wit?

2 Answers   Business Intelligence Analytics, NAL, TCS,


Explain about a task that really tested your analytical abilities?

0 Answers  


Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....

3 Answers  


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

0 Answers   IBM, TCS,


I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,


Difference between zabo and webi?

0 Answers  


rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?

1 Answers  


Categories