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 is log in cognos?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What are the types of catalogs in cognos?
What are the ways to import data into catalog?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What is a Pivot?
Mention the difference between ‘macros’ and ‘prompt’?
What is defined as Cognos Impromptu?
What is the difference b/w macros and prompt?
------------ Diff b/w MemberCaption and MemberDescription?
Can you define cognos powerplay?
What is the use of report studio?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
How we check the errors before running the report?
How to generate cubes in cognos?