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.
 | | 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.
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. |
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 |
