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 |
New coloums are added in database, then how you know in report level
What is looping and how to avoid it in framework manager?
What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
what is filter?give me one example that you created a report in your project?
what is hints in cognos and where we use it.
How to crate cubes in transformer ?
Can you define metrics designer?
What are the components used in web tier?
how to Explain a complex report at the time of interview ? please post the answer very urgent?
--------------Explain Table of contents?
Can you define query studio?