Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Automatically Update Frozen Reports in Dashboards
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Uncategorized > Automatically Update Frozen Reports in Dashboards
Uncategorized

Automatically Update Frozen Reports in Dashboards

exploreanalytics
exploreanalytics
3 Min Read
SHARE

Many of you are embedding Explore Analytics reports on ServiceNow dashboards, as well as Sharepoint, Google Sites, or other portals.

Often, these reports are live, but in some cases you may want to display daily, weekly, or monthly generated frozen reports. If a report doesn’t need to be live (for instance, for daily or weekly calculations), it may perform more quickly with frozen data. For more information on when frozen reports might be appropriate, see this earlier blog post.

Many of you are embedding Explore Analytics reports on ServiceNow dashboards, as well as Sharepoint, Google Sites, or other portals.

Often, these reports are live, but in some cases you may want to display daily, weekly, or monthly generated frozen reports. If a report doesn’t need to be live (for instance, for daily or weekly calculations), it may perform more quickly with frozen data. For more information on when frozen reports might be appropriate, see this earlier blog post.

More Read

Securing Enterprise Data and Computer Power
Guest Post by Ethan Yarbrough: Lessons Learned
What demographic responds best to mobile?
Increase Construction Company Efficiency with Cloud Services
Does the Future Lie with Embedded BI?

These frozen reports can be automatically scheduled to publish on a regular basis. Now, the republished reports can use the same URL, so that you can automate replacing the frozen report in your dashboard or portal.

We’re going to walk through an example, so you can see how it works.

 

Let’s suppose that we have the following report, which shows to our customers how our organization performed at meeting Service Level Agreements over the past week, by priority of incident:

We’ve decided we don’t want to show our customers the week-in-progress, so we generate this each week looking at the previous week. For that reason, we’ve decided to optimize the report by generating it as a frozen report weekly.

Luckily, it’s just a few easy steps to schedule this frozen report to automatically update in the portal. That way, even though the report is static, the data will be compiled automatically and replaced in the portal without any manual effort.

Here’s how:

  1. While the report is open, navigate to File > Schedule.
  2. In the Schedule dialog, provide a title, select Frozen – keep a data snapshot, and check Overwrite the previously published view and reuse its id:Screenshot 2015-11-02 19.17.45
  3. Click the Next dialog to set the Options for the report, and Next again to define distribution. You can leave the email information blank.
  4. On the Schedule tab, define how frequently you want the data to update. In this example, set it to “Weekly” to update the data at the end of each week:Screenshot 2015-11-02 19.15.57
  5. Click Finish. You’ll be presented with the HTML embed information and the URL.
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Change Leadership and Sales Offer Common Challenges and Solutions

4 Min Read
data security breach
Uncategorized

HIPAA in a HITECH World: HIPAA Violations on the Rise

19 Min Read

The Raging Debate Over The Link Economy

6 Min Read

Predictive Analytics: Investing and Selecting Software Properly

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?