how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please

Answer Posted / ark chowdary

There is no mandatory for maintain Dimension and Facts.

We cant specify.why bcz its depends on clent requirement
itself they will tell everything.

Normally u can say like this

Dimensions------> we have Product Dimension,
Time Dimesion,
Country Dimension,
Customer Dimension,
Order Deimension,
Shippers Dimension,
Order Details Dimension,
Inventory Dimension,

Facts------------> We have Sales
Fact,Revenue,Discounts,Quantity,Price etc................

I hope now its clear for u.

If still any thing else pls letme know.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is zero-foot print?

695


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

1729


please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

1846


Write some methods to apply securities in framework manager model?

750


9. What was the most complex type of report you dealt with?

1806






-----------------What is Determination Model?

1785


How to do Performence Tunning in Cognos Reports?

2149


Can you define slice?

704


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6149


What is cognos reporting tool?

699


Write various indexes used in cognos?

652


What is main advantage datawarehousing over oracle?

635


Can you define cognos powerplay?

728


can we insert all types of charts in a list report? what r the realtime prompts?

1767


Can you define a catalog and types of catalogs in cognos?

656