Reorganizing Your Data and Hierarchy with NI DIAdem

Publish Date: Jan 08, 2015 | 1 Ratings | 4.00 out of 5 | Print

Table of Contents

DataFinder Server Edition 2013 and DIAdem 2012 SP1 or later  allow you the flexibility to view data in a way that makes the most sense to you.

Before beginning this portion of the tutorial, make sure you complete part 1 and set up your ASAM ODS Server in 12 steps. To follow along with this tutorial, please email stephanie.amrite@ni.com to obtain the sample file set and download the DIAdem tool to create your own data models located in the upper right corner of this page. 

If you are using DataFinder Server Edition 2013 and DIAdem 2012 SP1 or later, follow the tutorial below. 

If you are using DataFinder Server Edition 2014, please click here to learn how to reorganize your data. 

Reorganizing Your Data Hierarchy 

Now, lets begin reorganizing how we view our data in an ASAM ODS client. 

1. Within the DataFinder Manager, after optimizing your custom properties, click on the Export a Client Configuration... button. You can chose to de-select the Include DataPlugins in client configuration box. When you click OK, chose a location to save the *.URF file.

Figure 1. In the tool bar select the Export a Client Configuration... button. 

Figure 2. Set up your parameters and click OK. 

 

2.  Navigate to where you saved the URF file and double-click it to register the ASAM ODS Server. You will see a message like the following that tells you the registration was successful. Click Close.

Figure 3. This message box confirms the *.URF file was registered properly. 

3.  Open DIAdem. 

4.  In the Navigator panel, go to Open Data Store. 

Figure 4. Navigate to Open Data Store.

5.  Click on the EngineData_ASAM-ODS@<computer name> (or whatever you decided to call your ASAM ODS Server) and click OK.

Figure 5. Access the data in your ASAM ODS Server by selecting the proper *ASAM-ODS instance. 

6.  Your ASAM ODS Server is now open. It is by default organized to show the data by Year, then Month. In this example that was created, all of the data was saved in August 2013. This isn’t a useful way to  extract meaning from this data set, so let’s use a tool to reorganize the data.

Figure 6. The default configuration for an ASAM ODS Server in DIAdem

7.  The tool I want to use is a VB Script.  We are going to set up DIAdem with a hotkey to run the script. This will allow us to run the script directly from this panel instead of switching to the SCRIPT panel to load and run the file. Go to DIAdem Scripts and pick a shortcut key. I chose F5 and clicked on it.

Figure 7. Set up a hotkey (F5) to run a VB Script. 

8.  After clicking on F5, you will be presented with this message. Select Yes and assign the script Main.VBS to the F5 button. 

Note: If you want to follow along and use the sample data I am using in this tutorial, email stephanie.orci@ni.com. To use the script, download the ZIP file in the upper right-corner. 

Figure 8. Select Yes and assign script Main.VBS to this button. 

9.  Now we need to set up how we want the data organized. We can use any property saved to the file at the File or Group level. In this example, I want to organize the tests first by Author. Run the script by hitting Shift + F5 or clicking the F5 button in DIAdem. You will see the following dialog box.  To build the hierarchy, you need to know which level your property is saved on. At this moment you can either organize your data by properties in the File level or in the Group level, but you cannot combine the two. 

For this example, our properties are saved at the Group level, so select the Group radio button.

Figure 9. Dialog box for the tool that lets you reorganize the view of your data. 

10.  Then go to the <Select a property> drop down menu. You will be shown all of the optimized properties and for this set of data I will work with the Engine Data. The order in which you select properties is important and will dictate how the data is organized.

Figure 10. Use the drop-down menu box to select the order of how you want your data to be organized. 

I set up the following data hierarchy with four levels of information.

Figure 11. Set up as many levels of properties that you want. 

11.  Click the Preview… button to see the new way your data can be reorganized. You will see that there are four levels to the data organization and you can dive down to find exactly the data that you need.

Figure 12. The Preview... buttons allows you to browse your new data hierarchy, which is much more intuitive to browse than a typical data organization system based on a file name.

Saving the Data Model

If you want to save this configuration so that you can use it define the custom hierarchy of your DFSE ASAM ODS Server, you can complete the following steps.

1.  In the Create ASAM Model Hierarchy for Engine Data dialog box, click Save... and choose a location for the *.asamconfig file.

Figure 13. After you are satisfied with your preview, save your *.asamconfig file so you can use it define the custom heirarchy of your DFSE ASAM ODS Server.

2.  You will see this message box which tells you to go back into the DataFinder Server Manager and apply the new settings.

Figure 14. Dialog box indicating the *.asamconfig file needs to be applied to the ASAM ODS Server. 

3.  In the DataFinder Server Manager go to Settings » ASAM ODS Server… and use the drop down box for Select model hierarchy: to Import user defined hierarchy…

Figure 15. To apply your custom data model, select Import user defined hierarchy...

4.  Browse to the *.asamconfig file you just saved and click OK.

5.  Restart the DataFinder to have the changes take effect.

6.  You can now go back into DIAdem, re-open the Data Store EngineData_ASAM ODS@<computername> and the new way to view your data will be displayed every time you open your client. 

The flexibility to change the way your view your data is imperative to managing and making key decisions from your data. 

Additional Resources

To request help email DIAdem.PSEs@ni.com

Learn about National Instruments ASAM ODS solution

Learn how to use Uniplot to access data from the ASAM ODS Server

Back to Top

Bookmark & Share


Downloads


Ratings

Rate this document

Answered Your Question?
Yes No

Submit