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
Answer Posted / 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 |
Post New Answer View All Answers
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What is called a slice?
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
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is the information present in the cognos configuration file?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
Can you define metrics designer?
what are the errors faced while bursting the reports and how to solve those errors?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What is the advantage of using shortcuts?
----------------------What are the User Securities?
what are slowly changing dimensions? Why we are used scd?
What is cognos reporting tool?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days