how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please
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 are the different types of important services used in cognos?
what are the names of the reports that you prepared?
What is dtm?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What is a Folder?
Explain about scorecarding?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
------------ Diff b/w MemberCaption and MemberDescription?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
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.
How do you improve the performance of the Cognos Analytics report
What is set to be cardinality?
Explain the characteristics of cognos?
5. Which type of report you build more, list, crosstab or chart and why?
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