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

Answers were Sorted based on User's Feedback



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

Answer / harry

facts and dimensions are considered according to the
project requirement ,we cant say particular number ,its
depend upon the project environment ,if you want to know
more about fact and dimensions ,Cognos provides default GO
sale package by using that you will be able to get your
answer.

here are some facts and dimensions:

Dimensions are time, products, retailer type, activity
desc, sale staff, and retailer type, return reson, order
method, order header, sales staff...Etc

Fact is sales target, closing inventory, expected volume,
activity, return quantity, revenue,
Quantity, gross profit, netincome, lossess, margin, product
cost, unit cost, unit price, unit sale pruce...etc.

Is This Answer Correct ?    6 Yes 0 No

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

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

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

Answer / vijay kalyan.v

Hi Pinky....

To identify dimensions and fact tables we no need to have
real time exp. Just Assume few dimensions and think for
proper justifications according to ur Project.” But Stick
to Basic Concepts".

My Assumptions

Dimensions are Products, Location(Area),Time, Employees,
Retailers or Dealers, Inventory, Logistics.....etc

Fact (Measures)
Sales target, Returned Sales, Purchase Returns
Revenue, Quantity, gross profit, net income, losses,
margin, Fright, operational cost
unit cost, unit price...etc.

Good Luck

Is This Answer Correct ?    3 Yes 1 No

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

Answer / ammu

hi..pinky how u r entering with fake exp..i also thought to
enter..could u send ur mail id..

Is This Answer Correct ?    2 Yes 1 No

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

Answer / pinky

i know its depends upon the project.for interview purpose i
need the answer.i dont have realtime experiance.any body
answer me.....................
generally for sales project how many facrs and dimensions
and for banking project how many pls .............urgent

Is This Answer Correct ?    0 Yes 0 No

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

Answer / joe

hey.. send me ur email id too..
even i'm thinking abt the same..

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

How can we find out cardinality between two tables?

3 Answers   IBM,


Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?

7 Answers   Cognizant, Cognos,


How can we create a dynamic column name in cognos?

0 Answers  


what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running

2 Answers   IBM,


Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!

1 Answers  






If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in

2 Answers   HCL,


How to select multiple values from type-in prompt?

0 Answers  


In which types of reports does the page breaks applicable in Cognos...?

1 Answers   IBM,


What is snapshot ?

4 Answers   IBM, TCS,


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers  


----------------Diff b/w Dimensional modeling and Relational modeling?

2 Answers   Cap Gemini, L&T,


What is the difference between ‘macro’ and ‘prompt?

0 Answers  


Categories