Mumpster http://www.mumpster.org/ |
|
BI using VISTA http://www.mumpster.org/viewtopic.php?f=26&t=1668 |
Page 1 of 1 |
Author: | sumitsaurav [ Tue Nov 29, 2011 9:34 pm ] |
Post subject: | BI using VISTA |
Hi I am new to vistA and GT.M. I am interested in using BI tools for vistA and GTM implementation at my workplace. How can I directly build cubes from GT.M instead of taking data to an RDBMS? Best, Sumit |
Author: | whitten [ Mon Nov 05, 2012 3:34 pm ] |
Post subject: | Re: BI using VISTA |
I assume BI stands for Business Intelligence. I assume when you say "build cubes" you are talking about online analytic processing (OLAP) cubes such as those discussed here: http://publib.boulder.ibm.com/infocente ... eatemd.htm Lessons in this tutorial Optional: Start the tutorial here You can skip the previous modules and start the tutorial here by completing a few short steps. If you already completed the previous modules, do not complete these steps; go to Lesson 1. Lesson 1: Creating a complete cube model In this lesson you build a cube model for OLAP analysis that describes relationships in the relational data. The cube model enables you to define the aspects of the data that are important for the analytic needs of JK Superstore. Lesson 2: Adding a hierarchy to the Time dimension In this lesson, you add the Calendar Year hierarchy to the set of OLAP metadata that you imported in Lesson 1. Lesson 3: Creating a cube In this lesson, you create a cube called Price Analysis that includes the metrics and dimensions that are needed by the JK Superstore business analysts. Cubes are a critical component of your OLAP metadata and are used by reporting applications, like Alphablox. Lesson 4: Deploying your OLAP metadata to the DWESAMP sample database In this lesson you validate the model, and then deploy your metadata to a database. Lesson 5: Creating MQT recommendations using the Optimization Advisor wizard In this lesson you use the Optimization Advisor wizard to create SQL scripts that can build a set of recommended materialized query tables (MQTs) for a cube model. MQTs aggregate commonly accessed data to speed up query performance for applications that issue SQL-based, OLAP-style queries, such as Alphablox. Lesson 6: Deploying your recommended MQTs In this lesson, you use the DWE Administration Console to run the SQL script to create the recommended MQTs that you designed in the Design Studio. It might be interesting to see what is necessary to integrate OLAP Cubes into VistA. It might involve the existing definitions and meta-data, and it might require more. |
Author: | trice001 [ Tue Apr 04, 2017 10:57 pm ] |
Post subject: | Re: BI using VISTA |
thanks |
Author: | trice001 [ Tue Jun 20, 2017 5:02 am ] |
Post subject: | Re: BI using VISTA |
thanks |
Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |