SAP BW

Report to Report Interface

SAP BW

Last Updated on Thursday, 17 February 2011 22:33 Written by Adobsessy Thursday, 17 February 2011 22:21



 

What is a lookup table?

SAP BW

Written by DataBase BW Wednesday, 19 May 2010 03:13

A lookup table is used to display information from one table based on the value of a foreign-key field in another table.

What are Aggregate tables?

SAP BW

Written by DataBase BW Wednesday, 19 May 2010 03:13

Aggregate table contains the summary of existing warehouse data which is grouped to certain levels of dimensions. Aggregate table gives better performance for many reporting needs. Aggregate table contains the [measure] values, aggregated/grouped/summed up to some level of hierarchy.
 

What is a level of Granularity of a fact table?

SAP BW

Written by DataBase BW Wednesday, 19 May 2010 03:13

Level of granularity means level of detail that you put into the fact table in a data warehouse. For example: Based on design you can decide to put the sales data in each transaction. Now, level of granularity would mean what detail are you willing to put for each transactional fact. Product sales with respect to each minute or you want to aggregate it upto minute and put that data.

How are the Dimension tables designed?

SAP BW

Written by DataBase BW Wednesday, 19 May 2010 03:13

Most dimension tables are designed using Normalization principles upto 2NF. In some instances they are further normalized to 3NF.
 

Page 1 of 3

«StartPrev123NextEnd»

Login Form (Can use your Gmail Acct)

Latest Comments

Copyright © 2017 Interview Questions, Tutorials, Certification Questions. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.