How to schedule the report in Cognos? And i have 2 users
u1,u2. how to schedule the report for these 2 users(the 2
users will get result once for a week) but u1 get the
result on every monday to his inbox,and u2 get the result
on every wednesday to his inbox.
- 3 Answers
- 12093 Views
- UHG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / arijit mondal
Create two different Jobs, with two different sets of
parameters and delivery schedules, options. U can use the
same report if You wish to send the report output as email
attachment..or create a Report view if You wish to secure
the Report outputs by user. Hope that helps
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / harry
Example - Schedule a Report
You can schedule entries that are stored in Cognos
Connection, such as reports, queries, and agents, so that
they run at a time that is convenient for you.
In this exercise, you will learn how to
save a report as a report view
schedule a report so it runs daily
use the schedule management tool to view the status of the
schedule
You are a business analyst for the Great Outdoors company.
You want to schedule the Return Quantity by Product Line
Chart report because some people in your organization need
the data updated daily. You schedule the report to run
daily, and then check that it is properly scheduled.
Things to Notice
When a report runs according to a schedule, the report
output is saved and appears in the Action column in Cognos
Connection.
At any time, you can click the arrow next to the help
button, and click Go to the Welcome Page to return to the
Cognos 8 Welcome page.
Steps
Open Cognos Connection:
Start your Web browser.
In the address bar, type the URL supplied by your
administrator, and then press Enter. The URL looks
something like this:
http://servername/cognos8
In the Cognos 8 Welcome page, click Cognos content, click
the GO Data Warehouse (analysis) package, and then click
Query Studio Report Samples.
Locate the Return Quantity by Product Line Chart report.
You can also use any one of the Cognos sample reports.
Create a report view for a daily view of the report:
In the Actions column, click the create a report view
button next to the report.
In the Name box, remove the words Report View of from the
beginning of the name, type (Daily) at the end of the name,
and then click Finish.
A new entry appears in Cognos Connection, with the report
view icon .
Schedule the report view to run daily:
For the entry, in the Actions column, click the schedule
button .
Under Frequency, click the By Day tab.
Accept the default time and other defaults.
Click OK.
Check the schedule:
Next to the my area icon , click the down arrow, and click
My Activities and Schedules.
Click Schedules.
In the Filter pane, select Any status and Any priority, and
click Apply.
If you are accepting the default settings, you will not see
any changes in the schedule.
Your report view appears in the list of scheduled reports.
Try on Your Own
Modify the schedule so that the report runs weekly.
Tip: In the Actions tab, click More, and then click Modify
the schedule.
Permanently remove the schedule.
Tip: In the Actions tab, click More, and then click Remove
the schedule.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / rizwan
Buddy the simplest is by creating Report views....
| Is This Answer Correct ? | 2 Yes | 4 No |
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
What is difference between drill through and drill down?
what is cognos architechure
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
How can we find out cardinality between two tables?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?
What is Clipboard? How to import XML file into Clipboard?
Teradata 
