-------------How to do Bursting a Report?
Answer / the who
requirements for bursting a report- you need to specify the
users for whom you are bursting the report. create a query
item in the query with the targeted users in the query
definition. now from the file menu, select burst options.
you get a daiogue box, click on 'make report available for
burstin' or what ever. now all the burst groups etc. are
enable for editing. now select query of burst groups select
the query you are using blah.. blah.. and the receipent area
select the query that contains the data item you created
for users and select the dataitem blah...blah.. save the
report and run from cognos connection.
| Is This Answer Correct ? | 5 Yes | 2 No |
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
is cognos 7 is better than cognos 8
what is the security module used in cognos?
how can you create a project creation
How to pass multiple values from picklist prompt to sub report filter?
How do we convert from Numeric to be Words?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
What is Normalization?
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
what is the difference between native sql and cognos sql?
what is the difference between aggregation and role up aggregation ?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?