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
what is hints in cognos and where we use it.
What are the types of security?
how to perform single sign in cognos by using url?
Can you define pivot?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What are query items?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Explain informatica architecture?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What actually a project contains?
-------------How you design DWH?
What are the considerations regarding performance kept in mind while setting up cognos?
What is a Cube?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.