Interested to Buy Any Domain ? << Click Here >> for more details...
how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please
- 6 Answers
- 20660 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Answer / joe
hey.. send me ur email id too..
even i'm thinking abt the same..
| Is This Answer Correct ? | 0 Yes | 0 No |
what are typees of dimensions
how to Explain a complex report at the time of interview ? please post the answer very urgent?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
what is cognos architechure
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
what is log in cognos?
which type of project we r going to snowflake schema
Please explain the different stages in creating a report in cognos report net?
What are all the types of hierarchies?
Can any one tell me cognos training class in chennai? thanks in advance...
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.
Teradata 
