Ideas

Idea: DataManager - Compare & other "Test" blocks)

steve — Mon, 05 Sep 2011 10:41:04 -0400

Add new category of DataManager pre-processing blocks, "Test" blocks, alongside operations and sources, allowing you to compare sources and add assertions to your models. For example:

1. "Compare" - fails if the two input data sets don't match exactly (with exportable summary of differences)

For example, allowing you to run a well-known sample of data against your model, and verify the outputs are exactly right.

2. "Assert rule" - succeeds or fails according to the result of a user-specified formula

For example, you might define the rule "SUBSET_SUM(field1) - SUBSET_SUM(field2) = 0".

Enhanced Merge/Join Options

jlwils11 — Wed, 31 Aug 2011 11:25:59 -0400

Are there any plans to enhance merge/join functionality to something similar to that of SQL?
More specifically - options that exceed value matching (ex: value comparison with static values or value comparisons between two tables that are not direct matches).

I spend a *lot* of horsepower trying to resolve the above and it typically ends with me appending the second table to the first, then creating a column which uses an unique_list / intersection / series of subsets.

Example:
Table 1
Employee Name | Extension| Job Role | Start Date | End Date
John Wilson | 1| agent | 1-may-2010 | 1-jan-2011
Jacob Harvell | 2| agent | 1-dec-2010 | 1-dec-2011
John Wilson | 1 | manager | 1-jan-2011 | 1-dec-2011
Billy Bones | 2 | agent | 1-may-2010 | 1-dec-2010

Table 2
Reported Date | ntlogin | handle time
1-Feb-2011 | 1| 120
1-Feb-2011 | 2| 7

If I only want to import handle times of agent data and bind their names I would need join conditions similar to
Tbl_1.ntlogin = Tbl_2.ntlogin AND Tbl_1.Job_Role = 'agent' AND Tbl_1.Start_Date <= Tbl_2.Reported_Date AND Tbl_1.End_Date > Tbl_2.Reported_Date

This is one example of many that I run into.
Currently, with only a match value join,I have to append the data and do the above by creating a column and performing a unique list / intersection / subsets to get the Employee name populated and then filter those that null.

Thanks,
-John

Idea: DataManager - Multi block copy?

TomW — Wed, 31 Aug 2011 09:31:23 -0400

Hi - I was wondering if there was a way to duplicate multiple operations within the DataManager. I am currently having to copy the same process 11 times and change only a few of the options within.

Thanks - Tom

Prevent copy paste from Details and Table view

Mees — Tue, 23 Aug 2011 06:11:14 -0400

Sometimes data published with Omniscope reports is so confidential, owners that publish the data do not want users to copy and paste the data into Excel and distribute it from there based on their own terms.

I would be nice to have an option to prevent users from doing this.

Total value in pie chart

Mees — Thu, 25 Aug 2011 14:43:31 -0400

Option to show total value of value that is counted for in pie chart. Sum of all pie parts.
Especially valuable in case of a Pane split and you have multiple pies.

Is it possible to include a feature on pivot tables which allow creating formula based on the result

OmarKhan — Mon, 22 Aug 2011 12:35:45 -0400

Is this possible now.

Pivot Operation needs "case sensitive" option

pgarces — Thu, 18 Aug 2011 15:12:25 -0400

Pivot Operation in DataManager is de-duplicating record when record is not a duplicate

Hi,

I am having an issue in DataManager, where I am using the De-pivot operation to make some changes to the dataset. Once done with the changes, I connect it to the Pivot operation and now have less records than before. No records were removed and technically there are no duplicate records. After further investigating, I found that the Pivot operation is de-duplicating a record that it shouldn't. The records are similar, but since the first character is capitalized in one record and the other is not, (ex. "Paul" & "paul"), technically they are not duplicates.

Any suggestions on how to work around this or if this is a know issue?

Thanks,

Paul

Copy-Paste: Global "Copy selection" option?

steve — Mon, 15 Aug 2011 06:13:36 -0400

Add in the Data menu, a new option "Copy selection" (with Ctrl+C shortcut) which copies your selected data (in any view) to the clipboard, just as if you had copied it from a Table view?

Probably using all fields, or fields currently configured to show in the details popup.

Idea: Table View - "Go to" shortcut?

steve — Mon, 15 Aug 2011 07:16:57 -0400

As in in Excel. Shows a dialog where the user enters a (visible/filtered) row number and/or column name. Scrolls to, and selects where appropriate, that cell/row/column.

Ctrl+G shortcut.

Might also be useful to include a "next matching value" option. You enter some search text, and the table view selects the next matching cell in a left-to-right-then-down direction.

Useful when you're editing and don't want to filter?

Idea: Universal 'Add' button

steve — Mon, 15 Aug 2011 05:16:24 -0400

There are currently two 'Add' buttons in the application toolbars:
"+" (add tab)
"Add view"

Idea: combine these into a universal "Add" button for adding views and tabs. In the drop-down you would have two sections: a matrix of view icons, and a list of tab types.

Expand values: Add columns, rather than overwrite?

steve — Mon, 15 Aug 2011 05:06:02 -0400

Currently "Expand values" in Table view overwrites columns to the right of the one you are expanding (albeit with a warning). It would be safer if, by default, it inserted new columns instead, to avoid accidentally overwriting data.

Idea: Date/Time - Duration format?

steve — Mon, 15 Aug 2011 05:02:09 -0400

Add ability to show a duration such as "27:15" for 27 hours 15 minutes?

Examples of different formats:

27:15
27 hours 15 minutes
1 day 3:15

Currently you have to use a date field which only works for values that represent points in time (so durations beyond 23:59 are not supported) or a decimal field representing, for example, 27.25 hours.

This could either be an option for date fields, allowing currently 'illegal' date/time elements such as 400 days or 27 hours.

Or as a "show as duration in [days/hours/minutes...]" option for decimal fields, allowing a fractional value such as 27.25 to be formatted as a time.

Idea: Table View - Field Picker should not hide field names?

tjbate — Thu, 11 Aug 2011 12:19:56 -0400

Currently, the Table View field picker on the View Toolbar that lets you select which fields will be displayed and in what order in a Table View drops down to obscure several field names. It should not cover any column/field names...

Idea: Colour-code empty, uniform and unique values or read-only fields?

steve — Thu, 11 Aug 2011 12:31:07 -0400

Data > Manage Fields should highlight empty fields so as to speed the process of identifying and deleting them

(externally submitted via an error report)

Autosave

steve — Thu, 11 Aug 2011 12:38:34 -0400

Could you please create an autosave feature in the program? it will be helpfull for all users, such as MS word. I'm doing the arabic translation and i couldn't find that fuction in the program so i wanted to suggest it to you. Ibrahim

(externally submitted via an error report)

Named query cycling

steve — Thu, 11 Aug 2011 12:36:45 -0400

Value Cycling: should allow named query cycling and aggregated cycling e.g. watch the population of multiple cities growing relative to each other year by year on a country map.

(externally submitted via an error report)

Stacked area charts

Alk — Wed, 10 Aug 2011 06:13:07 -0400

Hi, it would be very useful to have stacked area charts.

Zoom function on Content Views

stilley — Fri, 05 Aug 2011 15:56:22 -0400

Hello, I am having problems with the zoom function on my content views. It doesn't seem to hold the zoom when I navigate away from the page and back to it. I would like to be able to use this function to size images and it is necessary that it hold its settings just as the font size holds its settings.

Thanks!

Bar Charts

OmarKhan — Mon, 25 Jul 2011 10:09:33 -0400

Possibility to rank subdivised bar charts on choosen criteria.

Column filter on Field Organiser block

aknotts — Wed, 03 Aug 2011 04:59:22 -0400

Would it be possible to add a filter to the Field Organiser block in the same way it appears at the top of a field list on a table view. This is to make it easier to find columns when there are loads in the field organiser.

Thanks

Get an overview of the Scheduler tasks

Mees — Sun, 31 Jul 2011 16:50:16 -0400

Hi, we are configuring the Scheduler for a certain chain of tasks.
Works fine, but it would be very helpful to have an overview of the various tasks configured.
Screens are quite small and you must edit a task to get the details.

A table with all the tasks and values set (ie Parameter values), would be helpful

Textbox feature in the visualisations

shamong — Wed, 27 Jul 2011 03:52:42 -0400

Hi,

Is there any way where a textbox can be inputted into the charts itself to record any observations and comments?

Thanks!

Idea: Import - Bloomberg bulk data via BDS/BDH?

steve — Tue, 26 Jul 2011 04:51:33 -0400

Currently Bloomberg connectivity supports the BDP (Bloomberg Data Point) function, allowing you to pull in a single value for each record.

Idea: allow use of BDS (Bloomberg Data Set) and BDH (Bloomberg Data History) to pull in multiple rows for each record (such as historical prices).

http://www.gsb.stanford.edu/jacksonlibrary/articles/databases/dbguides/bloomberg.pdf
http://www.wilmott.com/messageview.cfm?catid=4&threadid=61402
http://www.wilmott.com/messageview.cfm?catid=10&threadid=61185

Field Organiser: Defining value colours, shapes?

steve — Tue, 26 Jul 2011 03:51:53 -0400

Add ability to assign colours and shapes to values in Field Organiser?

Currently you can only do this after loading data into the DataExplorer side of Omniscope and accessing:

Data > Manage Fields > Options

Idea: Table View - "Freeze panes" ?

steve — Tue, 26 Jul 2011 03:31:41 -0400

As in spreadsheets, so you can choose to always show one or more columns at the left, while you scroll sideways to the right?

Ideas: Layout - Zero view spacing (touching views)?

steve — Tue, 26 Jul 2011 03:30:29 -0400

Allow view spacing to go down to zero? Currently it has a minimum of around 5 pixels for the drag-able dividers. Perhaps have "Freeze view dividers" option, which when ticked removes this minimum.

Automatically Update Stale if Omniscope runs out of memory when updating block in DM

Alk — Mon, 18 Jul 2011 05:58:40 -0400

I have a workflow many cells within it and I often get "Omniscope has run out of memory" errors for some of the blocks and all blocks below that become Stale.

To resolve this, I have to select "Update Stale" and the blocks will update, often resulting in a block further down the workflow to become stale, where I have to click "Update Stale" again and repeat this process 4-5 times to update the whole workflow.

It would be very convenient if Omniscope waits 5 seconds and runs the "Update Stale" automatically if there is a out of memory error when updating a block in DM - and to prevent an endless loop of this, stop and report an error after 3-5 attempts of updating stale blocks if Omniscope is still on the same block.

Specify formulas at the end of the column

pkanther — Tue, 05 Jul 2011 04:56:25 -0400

Hi,

I have a created a numeric column using the formula field. I need to specify a formula at the end of the column. We can use a lot of formulas using the grouping value functionality (like mode, number of records etc) but I need to insert a specific formula. When I construct bars and pie diagrams etc, I need that calculated value calculated to come as a representative value for that particular column.

I have contacted a person from your company before who said that this functionality is yet to be developed in Omniscope.

Would that be possible?

Thanks
Purnima

Colours in Data, Manage Fields - enhancement request

aknotts — Mon, 04 Jul 2011 08:18:10 -0400

In the field organiser, formula fields are shown in the colour blue. If you convert the formula to statics but don't erase the fields changes to black however the formula is still stored against that field. Would it be possible to show these in a different colour so it is easy to identify which fields have formulas behind them even if they are static fields? eg black for statics, blue for formulas, green for statics with a formula behind them?

Thanks

Andy

Selected In Data in Tile View

benjamin — Mon, 27 Jun 2011 05:03:28 -0400

Hi

I think it would be best to start with my aim and then say what problems i have in omniscope

Suppose i have a database which list every supermarket and location (E.g Tesco,Sainsburys ,Morrison Etc)

I want my first graph1 to be a tile representation which groups by Tesco /Sainsvurys/Morrisions .

I then want a seperate graph2 which uses "selected data" from graph1 and then this is a tile graph which groups by region (Say Scotland/Wales/England )

I then want a seperate graph3 which uses selected data from graph2 and then this is a tile graph which groups by say sub region.

Etc

The problem is that i can use "Selected data" on graph2 but when i select data from graph2 the data record pops up and hence does select the data.Beleive this is becasue data in graph1 is already selected.

Any help would be much appreciated

Thanks

Ben