Using the DataManager workspace (2.6+)

Defining, saving and bookmarking permissioned data sources

Beginning with version 2.6, Omniscope features a new drag-and-drop visual workspace enabling non-technical users to import, assemble, transform (aggregate, de-pivot, tokenise, etc.), filter, sample, scramble and export tabular data sets, with no knowledge of SQL.  

File	List of values	Batch append files	OLAP cubes	Operations
URL	Sequence of values	Lookup data	Online Sources/Connectors	Outputs
Database table (or view)	File metadata	Demo data	Merging feeds

 

View Toolbar

Block Tools:  Block note: allows the user to insertcomment in the Block          Rename: allows the user to Remane theBlock name          Load into Omniscope : Load datainto Omniscope          Update data: Load data from Omniscope(Table)to the block.          Update Option: These settings allow you to customise howOmniscope checks for changes for this block. =>can be Never-Auto or Scheduled          Preserve formulas output:Keep the formula when creating an output file.          Create duplicate : does createa duplicate of the block          Create a snapshot: Create asnapshot of the block          Replace with snapshot: Replacethe block with a snapshot.          Bookmark This block: will create a“shortcut” under Bookmark menu         Explore to: Allow you to open a file          Reset size: reduce the size of the block          Maximize: Maximize the size of the window         Remove others: Remove ALL of the blocks except for 'Rename(snapshot)'?         Remove: Remove the block

 

Sources - using DataManager source blocks

Omniscope DataManager workspace opens to reveal a Data Bar/Blocks menu on the left side, and an Add Block menu is always available at the top of the drag-and-drop workspace.

File

The user can importe an Excel file including X number of worksheets, Omniscope will give the user the possibility to choose, individual, or a pair of working sheets:

 

-The name of the worksheet will appears under the buttonAll.    -The user can also create one block and append X number of Worksheet. or create one block for each worksheet

 

 

File Option Block, allow the user to drag a file to DataManager window and open a file.

 

By clicking on the block the user is able to:

-See/change the directory of the file.

-Browse a new file or open and edit the file used when selecting the option Edit.-To enter a Password -Modify and import a new worksheet if needed

-Change and modifythe setting of the Table Data

 

 

Data Manager also gives the possibility to change thesetting of the table if the user use the option selects table data. 

 

This Option gives the possibility to Configure/Select or Remove any rows, column and Headers.     For more details of how to configure and use File Option, click Here

 

 

URL

Data Manager can Import data from a remote data file such as an XML, CSV file or a SpreadSheet.

Database table (or view)

 

To see how to configure the Database in DataManager click Here 

List of values

List of values Block create a list of values that you can use as input to create any operation.

 

Sequence of values

Sequence of values generate a sequence of values betweenStart and End values.

 

File metadata 

FileMedia data Block, retrieves all information about all of the media files in afolder.

 

Batch append files

location of data files to be automatically appended into a single data set.

Batch append files, appends a set of files whith in a designated folder

 

Lookup data 

useful data available for free

Look up, Imports data from one of the Omniscope sample files to DM

 

Demo data

Same as Look up option, Demo data Imports data from one of the Omniscopesample files

 

OLAP cubes 

The OLAP cube source block provides connectivity to MDX-compliant multi-dimensional data structures (cubes) such as Microsoft SSAS and other cubes.

 

OLAP cube, Import data from an OLAP Cube such as SQL Server Analysis Services.

 

Online Sources/Connectors

Under the Blocks > Sources menu, the DataManager workspace provides access to a growing number of Online Sources/Connectors allowing you to control the import of data from remote sources to which you have access. Connectors enable Omniscope to access structured data sources unique to a publisher/platfrom or application directly via API calls, rather than via exported delimited data files or views/tables from relational databases imported using SQL statements and JDBC/ODBC protocols.   Note: Connectors for accessing, refreshing and synchronising with remote-hosted 'clouds' are available only from activated Omniscopes, not the free Viewer.

 

Other Data Bar Blocks in DataManager: 

Merging feeds

Online data sources ranging from freely-available searchable sources like Twitter and web searches to premium real-time data feed services like Bloomberg. Using Merging feeds

 

Operations

The DataManager workspace also allows you to define any sequence of  transformational operations by dragging Operations blocks onto the workspace.  Operations blocks are also accessible from the Mani Toolbar Data > Operations menu and are fully documented here. Transforming Data

 

Outputs  

Any number of different file output, publishing and distribution options can alo be defined using the DataManager data flow definition workspace. Output/export and disctribution/devliery options are fully documented here. Defining Outputs