Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Rookie Reporting question(s)

Rookie Reporting question(s)

It appears that not all of the data is being reported on.   For example, running Services by Service Team report, selecting %, only Site Administration is available, whereas there are scores of Service Teams configured.   Another example is when running the Request Activity Details report.    I'm seeing some rather older request activities whereas there are numerous requests that have been entered recently.

These are but a few examples.  I'm seeing similar issues with Analytics showing some data, but not all.   

I will take any help you can give me.   Thanks!

Mike

Everyone's tags (1)
8 REPLIES
New Member

Rookie Reporting question(s)

posted twice - duplicate

New Member

Rookie Reporting question(s)

check the last time all scheduled ETL jobs were run

Cisco Employee

Re: Rookie Reporting question(s)

It seems that you are using standard reports.  The specific script  that you want to make sure is scheduled is \\<newscale>\cognos\bin\update_datamart_std.cmd.

You  can also verify it by running the script on the command line once and  check the reports again.

New Member

Rookie Reporting question(s)

Same problem for me. When i ran scripts manually (std ,cube update) all the data show up in Data mart. Even though ETL jobs ran successfully data is not updating into data mart. Auto schedule is not workikng. Please Advice.

Rookie Reporting question(s)

mike, just curious...what version are  you on...

New Member

Rookie Reporting question(s)

Thank you, all. It was the update_datamart_std.cmd script that needed to run, for some reason hadn't run after the initial setup. Many thanks!
New Member

Rookie Reporting question(s)

How can ETLs be successfull if Auto Schedule is not working?

Please check with the Win System Admin as to see why your scheduled tasks are failing. Did you redeploy the app and overwrote the ETL on the RequestCenter side?

Cisco Employee

Rookie Reporting question(s)

Also the terminology of ETL is a little confusing here. 

Depending on whether you are using only standard reporting or if you also use Advanced Reporting, you have a different set of scripts that you need to schedule.  

When it comes to the issue of scheduling, you would want to make sure the script that is scheduled is the same that you ran manually and it did run successfully in the scheduler, as Emir pointed out. 

238
Views
0
Helpful
8
Replies