Better Business Through Data Analysis & Monitoring My Account

Reusing IDEA Dashboards

Tech Tip for Reusing Dashboards for Other Projects

IDEA 10 Visualization ButtonsWe had an interesting question posted to us recently. Can the dashboards created in one IDEA project be reused in another IDEA project?

The answer is, well, no - but sometimes, yes.

Generally, the dashboard in one IDEA project is using database files and fields that are not in other IDEA projects. The dashboards would not be compatible. But in some cases, yes, the dashboards could be reusable. If you are looking at basically the same data but in different data ranges, then you may be able to reuse an existing dashboard.

The key question to ask yourself is this: Do both IDEA projects have databases with the same fields and data types? If the answer is yes, then you can save time and improve your efficiency by reusing dashboards created in the previous project. For example, if you are performing a routine analysis that you do every month or every year, you might find it handy to reuse the dashboards.

How?

In our example, we analyzed an accounts payable file from the year 2005 and created a set of dashboard panels. That was “Project 1.” Now we want to analyze the accounts payable file from the same enterprise system, but for the year 2006. This will be “Project 2.” The two IDEA databases contain the same fields, just different transaction records.

2005 & 2006 AP Trans Database

STEPS:

  • In your first project, create the initial dashboard and save it.
    • The dashboard will save in this subfolder of the current IDEA prjoect: Visualization.ILB
    • The file extension will be ".idash".
  • Next, create the new IDEA project and import the same files using the same file name, but using data from a different date range.
    • Reminder: the IDEA database's file name, field names and data types must match those used to create the initial dashboard.
    • NOTE: It is likely you will not want to import the data using exactly the same name between two projects. In our example, we have "AP Trans 2005 Database" in one project and "AP Trans 2006 Database" in the second project. In the second project, we performed a quick direct extraction using no criteria and including all fields on the AP Trans 2006 Database, naming the output "APTrans 2005 Database." This gave us a file in the second project having the same file name, fields, and data types as that used to create the dashboard initially.
  • Using Windows Explorer, navigate to the first project where the dashboard was created, then navigate to the Visualization.ILB folder inside that project
  • Find the desired dashboard’s “.idash” file and copy it. 
  • Paste the .idash file in the new project’s Visualization.ILB folder
  • In the new project, click Dashboards on the Visualization tab. 
  • Click the Home icon found in the upper left hand corned.

Select a Dashboard Screenshot

  • Double-click the dashboard you wish.  The view will refresh after a few seconds and display the new data in the views you created in the first project.  You will now be able to see the updated information.

Again –the new project must contain databases that use exactly the same files names, fields, and data types as the initial project in which the dashboard was first created. 

If you have questions about this, or other IDEA functions, please give our help desk a call at

888-641-2800 Option 4.  Or email us at helpdesk@audimation.com

Print

Number of views (1499)/Comments (0)

Tags:
Brad Newman

Brad Newman

Other posts by Brad Newman
Contact author

Please login or register to post comments.

Name:
Email:
Subject:
Message:
x
Using Data Analytics to Prepare for Fieldwork
20 February 2018

Using Data Analytics to Prepare for Fieldwork

Automating High-Risk Transactions with IDEA

See how a global corporation used IDEA to develop an automated process to prepare auditors for on-site work.

Read More

People. Processes. Tools.
5 February 2018

People. Processes. Tools.

Successful Integration of Data Analytics

Expert IDEA users share their experiences and advice for building and sustaining a successful data analytics program.

Read More

Planning & Scoping Your Audit with Data Visualization
1 February 2018

Planning & Scoping Your Audit with Data Visualization

Data-Driven Insights Save Hours of Effort

Here are some ways IDEA can help you plan and scope an audit using the data visualization features within IDEA.

Read More

Classroom Collaboration at University of Missouri - St. Louis
30 January 2018

Classroom Collaboration at University of Missouri - St. Louis

Student Learn to Develop Analytic Tests

Masters students attending the University of Missouri - St. Louis share their results using data analytics to assess risk, test 100% of the data population.

Read More

Do One Thing Every Day that Scares You
30 January 2018

Do One Thing Every Day that Scares You

Virginia Tech Students Gain Confidence Using Data Analytics

Learn how Associate Professor of Practice Nadia Rogers, CPA, introduced students to IDEA, including types of audit tests that can be performed within the software and various documentation aspects of an audit engagement.

Read More

New Features in IDEA 10.3
29 January 2018

New Features in IDEA 10.3

IDEA now runs faster and offers more flexibility than ever before

The latest version of IDEA introduced a host of new features and improvements.  IDEA now runs faster and offers more flexibility than ever before.

Read More

5 Ways Data Analytics Saves Time
26 January 2018

5 Ways Data Analytics Saves Time

Turn Hours of Work into Minutes

5 time-saving ways data analytics can help you shrink your audit time, while improving the quality of your work.

Read More

Tired of Wrangling Cumbersome Client Data?
24 January 2018

Tired of Wrangling Cumbersome Client Data?

10 Ways Our Importing Services Make it Easy

10 reasons to try our data importing services, which save you time, effort and undue frustration. 

Read More

A Journey in Using Data Analytics
24 January 2018

A Journey in Using Data Analytics

Testimonial from Brian Cullum

Read how Brian Cullum used IDEA to help identify a multi-million-dollar fraud based on the overstatement of the borrower’s lending base.

Read More

Planning & Scoping Your Audit
15 January 2018

Planning & Scoping Your Audit

With Data Visualization

Data visualization is changing the way auditors are communicating with their audiences. Easy planning, find risk areas and prioritize your scope of work.

Read More

Infusing IDEA into Your Organization
16 November 2017

Infusing IDEA into Your Organization

Building a successful and sustainable data analytics program requires a mix of people, processes and products...it all starts with collaboration.

Read More

Using Nested @Functions()
16 November 2017

Using Nested @Functions()

IDEA Tech Tip

Combining @functions in creative ways can open a wealth of new capabilities that you may not have known your IDEA software is capable of.

Read More

IDEA 10.3 Now Available
15 November 2017

IDEA 10.3 Now Available

CaseWare Analytics Launches Update

Newest release of CaseWare IDEA introduces key features and enhancements to help auditors, accounts and other finance professionals improve their audits.

Read More

Innovation Starts with IDEA
14 November 2017

Innovation Starts with IDEA

Wrap Up - Part 1

More than 100 IDEA users gathered in Houston on November 1-2 to learn new strategies for implementing and growing their use of data analytics.

Read More

RSS