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
- 20399 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between informatica power mart and power center?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
How to publish a package by running Java Script?
What is drill down and slicing and dicing whats the difference between them?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Write various indexes used in cognos?
What is the difference between a cascading report and drill through the report?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What is the function of cognos dispatcher?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
what is hints in cognos and where we use it.
What is called Cognos powerplay?
What is the difference between static and dynamic conditions?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
