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 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
| || ||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.|
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|
useful data available for free
| ||Look up, Imports data from one of the Omniscope sample files to DM|
| ||Same as Look up option, Demo data Imports data from one of the Omniscopesample files |
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.|
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:
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
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.
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.