General

Omniscope User Group: Scientific, medical, pharmaceutical and environmental

paola — Mon, 31 Mar 2014 12:55:53 -0400

Role of Big Data and generally data science is becoming more prominent in the medical and environmental research, and we would like to enable Omniscope users in these verticals to exchange views, ideas and experiences, seek advice or post links to interesting articles, like this one:
http://www.information-management.com/news/big-data-collaborations-tackle-root-drug-development-failures-10025526-1.html?utm_campaign=daily-mar%2031%202014&utm_medium=email&utm_source=newsletter

Connectors: Google Analytics - Client ID login error?

Valentina — Tue, 29 Apr 2014 06:08:12 -0400

Hi ,

I have created a Google billing account but the client ID and Secret do not seem to work.

I receive the error: Please log-in to Google.

Any ideas how to sort this problem?

Installation: Updating to Omniscope 2.9

Valentina — Mon, 28 Apr 2014 12:00:27 -0400

Hi all,

If I want to download Omniscope 2.9, do I have to delete the previous version first or it does not matter.

Scripting: Examples from D3.js Gallery?

daniel — Wed, 23 Apr 2014 09:13:31 -0400

Does anyone have examples where they have integrated D3.js visualisations into Omniscope?

https://github.com/mbostock/d3/wiki/Gallery

Filtering: Date filter endpoint input in 2.9?

OO83 — Thu, 20 Feb 2014 06:15:38 -0500

Hi,

The date filters in version 2.9 look to be only adjustable by scrolling.

Is it possible to allow start/end dates to be typed in order to manipulate/adjust date filters, please?

Thanks

Installation: Mac OS X - Omniscope Server

donald — Wed, 23 Apr 2014 10:51:42 -0400

Using Omniscope Server on Apple Mac OSX

Follow the instructions for installing Omniscope on Apple Mac OSX
http://www.visokio.com/kb/mac-installs

Start Omniscope and enter your license.
Omniscope will prompt to restart once the license has been authorised.

The Settings Server menu will only show menu items once a valid server license has been authorized.

Select the Settings menu, select Server, select "Omniscope Server ..."

A warning message will be displayed saying that the Omniscope Server will take over the current Omniscope Window, select "OK, start anyway"

The Omniscope Server window will be displayed.
Mobile Web server will display a network error as it cannot use port 80 unless run as root.
Change the Mobile Web server ports for http to 8080 and https to 8443 by selecting Config.

Omniscope Server is now running.
Select Exit to exit the server.

The following two command files will allow you to start Omniscope server directly, the first command file will run the server with the server control window GUI, the second command file will run the server without a control window.

Save the files and rename the extension from .txt to .command

Or use a texteditor and save the following command as OmniscopeEnterprise.command

NOTE: change the memory to match your system, this is set to 6Gb -Xmx6144m for use on a system with 8Gb of RAM installed

/Applications/Visokio\ Omniscope.app/Contents/Plugins/jre7/Contents/Home/jre/bin/java -Xmx6144m -XX:MaxPermSize=128M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=50 -XX:NewRatio=8 -XX:+UseG1GC -Duser.dir=/Applications/Visokio\ Omniscope.app/Contents/Resources/Java -cp /Applications/Visokio\ Omniscope.app/Contents/Resources/Java/Main.jar:/Applications/Visokio\ Omniscope.app/Contents/Resources/Java/lib/mailapi.jar:/Applications/Visokio\ Omniscope.app/Contents/Resources/Java/lib/smtp.jar:/Applications/Visokio\ Omniscope.app/Contents/Resources/Java/lib/pop3.jar:/Applications/Visokio\ Omniscope.app/Contents/Resources/Java/lib/imap.jar:/Applications/Visokio\ Omniscope.app/Contents/Resources/Java/lib/dsn.jar:/Applications/Visokio\ Omniscope.app/Contents/Resources/Java/lib/activation.jar:/Applications/Visokio\ Omniscope.app/Contents/Resources/Java/plugins/bccrypto.jar com.visokio.ent.EntLaunch

Formulae: Subset functions

Valentina — Wed, 23 Apr 2014 07:41:25 -0400

Hi

I am trying to use subset functions to do the following but it seems that more functions are needed.

I have a column with ID's and another column showing the steps of the ID. The Temp column shows the temperature of the ID at each step. Ideally I want to create a fourth column (like First step temp below) showing the temperature of the First Step only, across all same ID cells.

Hope it makes sense. Any ideas are welcomed. Thanks

ID Steps Temp First step temp
A First Warm Warm
A Middle Cool Warm
A Last Warm Warm
B First Warm Warm
B Last Warm Warm
C First Cool Cool
C Middle Cool Cool
C Middle Warm Cool
C Last Cool Cool

Security: Heartbleed bug CVE-2014-0160?

donald — Tue, 15 Apr 2014 13:54:37 -0400

This relates to the vulnerability listed for OpenSLL summarised by CVE-2014-0160 generally called the 'Heartbleed' security bug.

http://www.cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2014-0160

Visokio Omniscope
We do not believe that Omniscope is affected by this vulnerability.

Omniscope is written in Java and we have not received any reports that Java is affected by this vulnerability.

We have tested Omniscope mobile server with external Heartbleed checkers and no vulnerability was reported.

However, if you are presenting content hosted on Omniscope mobile server via a front end proxy or load balancer such as Apache or Nginx you should check the version of OpenSSL used on those products and take appropriate action. You are advised to do your own security and penetration testing.

The main Visokio website, KnowledgeBase and Forums are using a version of OpenSSL that is NOT affected by this vulnerability.

Downloads from our website are delivered through a third party content delivery network through http: and are not affected by this vulnerability.

Our activation server is not affected by this vulnerability.

Our alpha and staging test sites for our Omniscope mobile Alpha partners are not affected by this vulnerability.

Data type: Integer, Date or Category

TomRiggs — Mon, 14 Apr 2014 15:34:38 -0400

I have two dashboards. Both have a Period (month number) integer value that is selected from a SQL Server DB. Both fields are integer values in the database and both fields are set as Category types in the field organizer of both dashboards. Both are set as category filter types. However, one is in numeric order 1 thru 12 the other is 1,10,11,12,2,3,4,5,6,7,8,9. Any ideas of what I could be missing?

Formulae: RunningTotal - Count Steps?

Valentina — Tue, 01 Apr 2014 05:36:05 -0400

Hi all,

I am trying to create a column ( as in Steps) in order to count the steps of an ID based on the date. I tried to use the recordcount function but it returns the total number of records for each cell.Any ideas?

ID Date Steps
AW 3/5/14 1
AW 5/5/14 2
AW 6/5/14 3
RT 5/5/14 1
RT 9/5/14 2
UL 6/5/14 1
UL 7/5/14 2
UL 8/5/14 3
UL 12/5/14 4

Thanks in advance.

Merge/Join: Creating min/max day sequence from date range?

ALC — Thu, 27 Mar 2014 13:05:56 -0400

I have a column with a start date and one with an end date. The format in both these fields is the same. What I would like to do is turn the start and end date into a list which contains every single data between the start and the end date

Any suggestions?

Thanks - Anna

Merge/Join: Multi-table Vlookup Problem

Nemesis — Tue, 25 Mar 2014 04:05:10 -0400

Table 1
ABC
BCD
DEF
NDH
FRD
TRY
ENT

Table 2 Value
ABC 1
DEF 3
NDH 5

Table 3 Value
ABC 2
BCD 3
FRD 5
TRY 6

Table 4 Value
NDH 2
ENT 5
ABC 3

I want to pull up values for list in table 1 from table 2,3,4

I tried merging (1&2, 1&3, 1&4) uniques then appending all/ Appending all then merging with Table 1 but it gives duplicates. when i remove duplicates it using table 1 identifiers it removes few values like in ABC when all are appended it looks like

ABC 1
ABC 2
ABC 3

But i want something like one the same line
Value 1 Value 2 Value 3
ABC 1 2 3

Am unable to achieve this. Please help.

Layout: Colour keys display location?

davedunckley — Tue, 04 Mar 2014 10:38:48 -0500

Hi Guys,

Is it possible to move the colour key display of a Bar/Line View?. Say, to next to the data, rather then at the bottom?

Dave

Layout: Dynamic Header title using date range?

herrenbruck — Mon, 03 Mar 2014 19:41:31 -0500

I understand there is a way to use dynamic headers, {{ SUBSET_SINGLETON([My Category Field]) }}, which I have used. My questions is, is there a way to use this on a filtered field of date ranges? I've uploaded an example. If I change the Fill Month/Year to Jan 2014-Jan 2014, then my header will display how I would expect it (this is how it should open). If I reset the criteria to include all data, it says no value (which I expected). Is there a way for it display "Fills Between Apr 2013 to Jan 2014" (or whatever dates I filter it too)?

Connectors: DoubleClick Path to Conversion in 2.9?

Valentina — Thu, 27 Feb 2014 17:23:08 -0500

Hi,

Path to conversion report is not currently enabled in the API and I was wondering if in there are plans to add it.

Thanks in advance

Filtering: Categories and nested sub-categories?

OmarKhan — Fri, 07 Feb 2014 12:54:39 -0500

I just have a question on Omniscope that’s rather technical. I was wondering if you knew if it’s possible to affect sub-categories to existing categories.

To be more specific, imagine I have a category that divides countries between “emerging countries” and “developed countries”.
I would then like to affect the pertinent countries (that’s the subcategory) to its right category. For example, I would say
• Emerging countries
o Zambia
o Argentina
o Groenland
o Etc
• Developed Countries
o France
o Germany
o UK
o Etc
All of that, in the criteria tabs of Omniscope. I know you can do that in SQL and that its possible in Excel (please see below).
By your knowledge, is that something realizable on the dashboarding part of Omniscope?

The two fields I am trying to have merged together are “Markets” and “Market type”.
The details of which countries are emerging are contained in the formula. All countries that are not “emerging” are “developed”.

Formulae: Creating custom interval sizes?

DBuzacott — Thu, 06 Feb 2014 01:27:24 -0500

Hi,

We have a number of views that are split by value (decimal numbers). Currently we split this by a fixed interval It would be useful to be able to customise interval ranges to accommodate large value ranges. For example, we may want to split by value ranges such as 0-100, 100-1k, 1k-100k etcetera. FYI, in general we measure a sum (aggregation) of a cost field for a given category (i.e. number of categories with a total spend in a given range).

We can do this a little with formula fields (IFs and SUBSETs), but this is limited when applying filters. For example, if we set up a calculation for total spend, this requires us to fix in the calculation the fields over which it is calculated. So we may set the calculation over subset([Site]), but then if we filter the view by another field (e.g. [Year]) then it doesn't update the calculation field accordingly.

Ideally, we would be able to set this up in the view, rather than with a calculation field. The simplest method that I can think of is to allow custom interval ranges (i.e. not fixed-width) in the "Split" menu.
Is this a possible addition?

Thanks, Daniel

Connectors: Twitter API problems

chris — Thu, 23 Jan 2014 10:21:47 -0500

Hi,

The Twitter blocks in Omniscope currently do not allow you to connect. We are working on a solution and I'll post back once this is available.

Appologies for the inconvenience.

Mapping: Importing Geospacial polygon shapes?

davedunckley — Tue, 21 Jan 2014 08:56:09 -0500

Hi,

Is this supported?

Dave

User Groups: Looking for Omniscope users in Italy?

enrico68 — Wed, 15 Jan 2014 06:12:25 -0500

Hi,

My company has started to use Visokio about two years ago and till now I've tried to learn how to use this wonderful software by myself, only having the possibility to interact with other users using this forum.

For better trying to fully exploit Visokio capabilities, I'd like to ask if it's possible to be in touch with any other Italian Visokio users (better if based in Milan) to exchange ideas and solutions.

Any answer will be very appreciated.

Integration: Ability to import/export central Bookmarks list?

cgamolo — Thu, 02 May 2013 16:55:02 -0400

We have a few analysts creating files in Omniscope. It would be great to create a list of Bookmarks at one time and have each analysts import that to their own instance so that they don't have a re-create the list.

Scheduler: Propagate Failure in Chain Actions?

ALC — Thu, 09 Jan 2014 06:39:35 -0500

I have a Task List with a Chain Action set up with multiple tasks. The Propagate failure box is unticked however when anerror is encountered in one of the tasks, none of the remaining tasks are carried out. The failure action occurs as expected with an email sent with the log

What changes do I need to make to ensure that all the tasks listed below the one containing the error is executed?

Thanks, Anna

Scheduler: creating XML Actions files in file output?

andy_white — Wed, 08 Jan 2014 07:43:57 -0500

Hi guys,

In earlier versions of 2.7 it was possible to have a file output block that would create an xml file. This was basically just a straight text output so we could have a data manager setup that would batch append a number of files and then a field organiser that would create a number of small xml scheduler processes that would move the files into a "processed" folder. It seems in the recent versions of 2.7 and definitely in 2.8 this is much more complex (the xml output options put a number of preformatting in the output and doesn't pass "<" or ">" chars) - can we have this back as an option!!

Thanks!

Table View: Fading of colours?

bgrovens — Tue, 24 Apr 2012 09:47:23 -0400

Hi Visokio,

I searched the forms based on the table view coloring and this is all I could find was an idea:
http://forums.visokio.com/discussion/727

It appears that you can color code the view based on a given field. That works fine, the probelm is that Visokio automatically changes the color. For example you set the color to amber view the options menu CTRL-f. Turn the color key on via the toolbar/styles menu. You will see the color key is darker and the actual table is lighter. It looks as if Visokio is automatically making the color ligher. This process is almost always making the color look terrible. Is there an option to turn this process off?

Please refer to my attached picture below. Notice the color key shade and what actually populates on the page. I would want the colors to be the same.

Thanks for the help,
Brian

Pivot View: Date & Time Fields and Top 5 Text Categories.

rajeshbalu29 — Fri, 27 Apr 2012 01:53:12 -0400

Hi All,

I have a requirement of creating a pivot with x-axis as months - MMMyy and y-axis by top 5 Categories. Currently, the Pivot View is only supports aggregation by Text Category, but if I convert the MMMyy from Date/Time to Text Category, then it does not automatically sort them properly (chronologically)?

Also I need the same feature which we had in the Bar/Line View restricting only top 5 Text Categories in the Pivot y-axis view?

Regards, Rajesh B

Web Server: dashboard loads after switching tabs?

Mees — Thu, 28 Nov 2013 05:43:20 -0500

Hi there

When we open a mobile dashboard on a tablet, a new tab opens but the dashboard doesn't. Only after opening another (existing) tab and returning to our dashboard tab, the dashboard opens immediately.

Any idea what the solution might be?

Thanks
Arjan

Outputs: Exporting multiple pages to existing PDF?

kmatrix999 — Tue, 12 Nov 2013 08:21:18 -0500

I'm exporting multiple tab views to an existing PDF, inserting between pages of introductory text and analysis. This works fine, but- minor point- page numbering does not occur on inserted pages and original page numbering persists. Has anyone solved this one?

Connectors: Google Analytics API - Missing Dimension?

martins2 — Thu, 06 Jun 2013 10:38:58 -0400

Hello,

I'm using the Google Analytics feed in Omniscope and noticed that none of the "mobileDevice..." dimensions are available. The dimension I'm specifically after is ga:mobileDeviceInfo.

Thanks

Martin

Subset Functions: Syntax for Multiple Criteria on same field?

Master_Chief — Wed, 06 Nov 2013 10:33:24 -0500

What is the correct Syntax for performing an operation (e.g. SUM) using multiple criteria on the same field (e.g. > 5 and <10)?

Performance: DataManager De-Tokenize Block Is Slow?

cmollo — Wed, 16 Oct 2013 14:46:54 -0400

I am using a De-Tokenize block in my DataManager processing flow. About 71,000 records are fed into the De-Tokenize block and about 274,000 records flow out from the De-Tokenize block. It took 75 minutes for the De-Tokenize block to do its processing. The other blocks I'm using (Expand Value, Field Organizer) take around a minute or less to operate on the 71,000 records. I realize that the De-Tokenize block is creating a lot of new records, but 75 minutes seems really slow.

I am using Ominscope 2.7 Build 459 x64. My computer has a quad-core i5 2.6 GHz processor with 4 GB of RAM. Nothing else of any significance was running on the computer at the time.

Also, the progress spinner in the De-Tokenize block immediately displays 38% and stays at 38% the whole time. It would at least be nice to get an accurate indication of percent done.

Is there any thing I can do to speed-up the de-tokenize process?

Thanks,
Chris