Hai frnds,
Any body tell to
What is Granularuty in cognos Please help me.i can search in
so many browsers but i canot get the answer
Answers were Sorted based on User's Feedback
Answer / gopal
The lowest level of the information stored in the table
Ex-year
Quater
Month
day
day is the granularity.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / n v appa rao
http://blog.digitalviper.co.uk/2008/10/hi-following-question-from-divya-last.html
plz visit this site.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / amar
Let us take
sales
products
product_forecast
we develop the report from them with the fields subcategory
and amountsold..
then we got the wrong result.. because of granularity...
we resolve this by, Go to Framework manager and right click
on the products-->edit definition-->determinants tab--
>change the priority of subcategory from products..
then after publish package --> go to report studio and
report package and run the report.. You get result correct
finally...
if any more... amar.ongole@gmail.com
| Is This Answer Correct ? | 1 Yes | 2 No |
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?
How can you create prompts in framework manager?
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
What is meant by drill down?
what is query subject
Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?
what is crosstab space
how can you create a project creation
What is the difference between Conditional Layout and Conditional Block
9. What was the most complex type of report you dealt with?
What is a query set?
how data modeling is usefull to cognos?