All Discussions - Visokio Forums

Hosting Mobile Reports on Amazon EC2

MatthewLiddle — Thu, 26 Oct 2017 15:49:33 -0400

HI All,

I am experimenting with hosting Omniscope Server on Amazon EC2 platform. However I was wondering if there is a step by step guide available?

I have managed to successfully set up an EC2 Instance and install Omniscope, however I'm struggling to 'see' the report from outside the EC2 Ecosystem. I'm keen to test 2.9 Server but also see how 3.0 performs

Does anyone have any advice (FYI I have created an instance using Windows server 2016)

On a separate note, how have people found the performance of EC2 at processing mobile reports? I like the idea of auto scaling if demand peaks

Thanks

3.0 version testing: Some observations

acohen — Mon, 03 Apr 2017 06:39:38 -0400

Congratulations on launching the preview. Please find some initial comments below:

1) How does one configure an end user dashboard? At the moment the navigation is via datamanager and clicking on the Visokio eyes to view the reports.
2) Will it be possible to link data in two different datasets into one report on a joining field? For example if the field "Name" is common but everything else is not.
3) The Field Metadata seemed to give me the wrong number of records for the Demo:Hurricane data. The dataset has 2038 records however Field Metadata shows 909 records
4) The aggregation block does not seem to work for unique value list when applied to a dates field

Looking forward to future developments,

Pivot view 2.9: blank rows in multi-field breakdown

nick_scangas — Thu, 12 Oct 2017 12:01:04 -0400

I am getting blank rows after adding multiple fields on the Y axis. Please see attached. How can i remove these?

Thousands separator formatting : Commas in numbers

Cheyam — Tue, 10 Oct 2017 05:49:51 -0400

Hi Omniscope,

Is there a way to stop Omniscope from putting commas in every single number field interpreted by every block in the application?

- I have an R block in which output_data contains a number of integer columns. When they are retrieved from the R dataframe and processed in Omni theyre all get given commas. There are too many fields of differing types to go in and manually remove the commas from each integer field.
- When you have integers over three digits and try merge with another field without commas in the numbers the ones with commas do not merge with the ones without commas.
- When I have this fairly simple formula:'=COUNTIF(A:A,A' & (CURRENTROW()+ 2) & ')' in a field organizer I am returned with =COUNTIF(A:A,A1,071). (I know its sloppy to inject excel formulae like this but bear with me)

If I asked colleagues of mine they would agree that the frustrations and issues caused by this feature are multiples of this. Is there any way this can be addressed? Commas in numbers is a display feature and shouldnt exist in the datamanager. A suitable solution would be to stop the application putting commas in all formulae by default.

Thank you,
Chey

Open and edit .iok files directly from browser in SharePoint 2013

saintmarino — Thu, 05 Oct 2017 09:14:59 -0400

Hi, there is a requirement from our client, who are using .iok files in SharePoint 2013.

In previous version of SharePoint 2007, they would simply open these files directly by clicking on them, making necessary changes, and saving them directly in SharePoint. However, this does not work in SharePoint 2013.

When users click the file, they get options to Save and Cancel, which does not serve the purpose. We have tried adding the file extension .iok and the MIME type "application/octet-stream" in IIS, and allowing the same to be opened directly from browser by running the following powershell script:-

$webApplication = Get-SPWebApplication "our web application name"
$webApplication.AllowedInlineDownloadedMimeTypes.Add("application/octet-stream")
$webApplication.Update()

This does allow users to open the file directly in Omniscope, but they are unable to save the changes they make back to SharePoint. Kindly assist.

There is a second requirement, where we do not want to allow any other file type to be opened from browser other than .iok files. However, using the MIME type "application/vnd.visokio.omniscope-iok" does not work, we need to use "application/octet-stream". Any suggestions?

SearchRegex Formula not working

JohnMR — Mon, 18 Sep 2017 06:30:00 -0400

Hi Omniscopers,

I'm trying to use Searchregex formula to pull

=searchregex("^.{3}[A-Za-z0-9 ]+\K.",[Campaing],1)

Searchregex usually works but not when I add the "\" in \K I get an error: Error with formula: Invalid text """ - an open bracket, literal number, reference or function was expected.

When I remove the slash the formula works but I need that slash in it. Why is this not working?
Thanks,
John.

Graphical glitches due to Java graphics driver compatibility

steve — Wed, 13 Sep 2017 06:49:06 -0400

Occasionally our users run into compatibility issues between graphics cards or graphics driver versions, and Java. This might present itself as visual artifacts or black/transparent windows, and may be specific to secondary monitors. This may be introduced by a driver update you may not be aware has happened.

To resolve, locate installconfig.properties in your Omniscope installation folder (e.g. C:\Users\YOUR_NAME\AppData\Local\Visokio Omniscope app, or C:\Program Files\Visokio omniscope). Make a backup, then edit as follows. When done, restart Omniscope.

Find this line in installconfig.properties
#ADDITIONAL_JVM_ARGS=-XX:+HeapDumpOnOutOfMemoryError

Replace with the following line (note the removal of #), replacing the key/value pairs shown here with suggestions below:
ADDITIONAL_JVM_ARGS=-Dkey=value -Dkey2=value2 ... (etc.)
Or, if you have ADDITIONAL_JVM_ARGS property already enabled, append these after a space character.

Key/value pairs to try, most likely to help first:


-Dsun.java2d.noddraw=true
-Dsun.java2d.d3d=false
-Dsun.java2d.opengl=true

Try these individually, or combinations thereof.

If this doesn't help, try these more exotic options:


-Dsun.java2d.noddraw=false
-Dsun.java2d.ddforcevram=true
-Dsun.java2d.ddblit=false

If you find a solution, please a summary of your problem with the option needed as comments here. You should use the minimum options needed to solve the glitch.

Please see http://www.visokio.com/kb/installconfig for more information. Derived from: http://www.oracle.com/technetwork/java/javase/java2d-142140.html#gcgtf

Exporting Pivot view data into xls

enrico68 — Fri, 25 Aug 2017 08:14:37 -0400

I'm trying to understand if it's possible to extract to an xls file the data shown in a pivot where functions like the count of unique values are used to calculate aggregated data.

I followed what is indicated in the thread http://forums.visokio.com/discussion/comment/10597/#Comment_10597 but I've been able only to extract the details of the elementary records that are the base for the pivot composition.

Is it possible to extract the data as shown in the pivot table?

Since the pivot table is very big I would like to avoid to use the method of selecting cells on the pivot and use the cut and paste option.

Job Opportunity

aaronlewin — Tue, 22 Aug 2017 10:31:28 -0400

I work at a London based media agency, and my team is currently recruiting for data analysts that have experience with Omniscope.

Anyone wanting more info, or who knows somebody who may be interested please contact:
shoaib.ahmed@mediacom.com

Batch Publishing: Dynamic Content in Message Bodies (2.8+)

ddemarco — Tue, 13 Sep 2011 08:17:14 -0400

Would it be possible to add dynamic Content view behaviour to the Message Text Box in the “Email Output block”?

Omniscope Classic transition to 3.0

bfromson1 — Tue, 08 Aug 2017 12:28:22 -0400

Is there an automated way to convert classic Datamanager flows into v3.0, or do they need to be manually rebuilt using the browser interface.

Datamanager 2 in classic used to be the way to do this.

Value order for Text fields: Filter order/sorting

luukvanm — Wed, 10 May 2017 06:08:55 -0400

Hi,

What is the basic sorting for an filter? A customer of us wants to have the filter ordered alphabetically, I have found the option in the attachment to fix the ordering. But I was wondering, if a new value will be added to the filter, will this also be alphabetically sorted or will the new value be added at the last position in the filter?

Thanks,

Omniscvope v3, mysql on Mac

aknotts — Fri, 04 Aug 2017 04:11:54 -0400

I am trying to test the latest build of Omniscope v3 against mysql on my mac. We are looking to move from MS Sql Server so my mysql knowledge is zero! I get an error "The database jar file is not configured. Please configure and reconnect"

I have downloaded the JAR but don't know where to put it or how to get it on my path.

Any help gratefully received.

Thanks

Andy

Search and Replace: Large Amount of Data

CarenaLi — Mon, 31 Jul 2017 09:39:04 -0400

Hi all,
I am trying to do search and replace in my data,
e.g. in my data it shows "yt", then I need to replace it as "YouTube".

I have an Excel file of all short codes and their full names.
Is there any quicker way to do so?
Many thanks!
Carena

Data Manager: Exporting multiple .iok files to .xls

tron05 — Tue, 01 Aug 2017 07:36:58 -0400

Hi All

My level of understanding Visokio is very basic. I have a limited use for visokio and am hoping a solution to the below stated problem exists. I use Visokio Omniscope 2.9 viewer.
Problem: A set of *.iok files are published to a folder. I need to export each of the .iok files to .xls and load the .xls files to a database.
Currently I go into each iok file and go through the general export process from File menu. I was wondering if there was a automated way to export all iok files to xls. Is it possible to automate the process with a batch script?
Thanks for any help!

Website data SSL error : Cannot retrieve data from website

naruemon — Thu, 27 Jul 2017 04:26:02 -0400

We use Omniscope Server to feed the data from the website and set the schedule to get data every day. Every thing works fine for a month and no data can be retrieved later on... show blank. If we copied links to browser, we still can see the data.
Then, we tried to change the link to https but no luck. We got the error message 'SSL error'.

Anyway, if we run Omniscope file from other computer (Desktop version), the data can be feed with https without any error.
Could you suggest what could be the root cause? Thank you.

Date and time formatting: Times changing?

kim2604 — Tue, 18 Jul 2017 14:54:25 -0400

Omniscope is changing the date from what is in the database to what it is appearing in Omniscope. Two days ago the difference was 2.5hrs and today the difference was 1 day. We are using the system locale English United States setting which is the same as our DB. Because the date difference is not consistent, it is hard to understand what is going on.

Data preparation: CSV cell separator - more than 1 character

JamesPC — Tue, 18 Jul 2017 12:38:49 -0400

in CSV most common separator is the comma but sometimes other data contains a comma which I know the workaround is quotes but if it was a random thing like:
;%#£
then the likelihood of this appearing in the data is substantially smaller than a "," appearing.

Memory management: 32-bit limit exceeded on 64 bit machine?

Alexander — Fri, 13 Jul 2012 13:55:24 -0400

Hi - I get a strange notification in the command screen when running my scheduler.
As it is in the command screen, and not in Omniscope itself, I cannot send an error report.

I attached a screenshot, if you need any additional info please let me know. Thanks!

API Failure workflow

mttwnxn — Thu, 06 Jul 2017 06:37:10 -0400

Hi - if we are running API pulls via Omniscope (e.g. DoubleClick) and for some reason these fail (maybe an external factor such as API downtime) can we set up a workflow to be able to loop around and retry x number of times?

Data source: RSS feed fails to update in Server Scheduler

PaulAllison — Wed, 05 Jul 2017 09:43:28 -0400

Hi - I'm testing out the scheduler option in Omniscope Server and have built a simple IOK file pointing to the BBC News RSS feed which is scheduled to update every hour and collect the latest stories - http://feeds.bbci.co.uk/news/rss.xml

The stories update with no problems in the IOK file DataManager file (using the desktop software), and also when setting up the scheduled event (in the server app), but when it subsequently tries to run in the scheduler I see the following error in the event log

2017-07-05T08:31:37Z,BBC News,Started,,
2017-07-05T08:31:37Z,BBC News,Error,Update & Save BBC News,"Could not execute action: Error: va4e: Production error in BlockBlueprint-vei ""Field organiser"": com.visokio.vbam: com.visokio.va4e: Production error in BlockBlueprint-vei ""Append"": com.visokio.vbam: com.visokio.va4e: Production error in BlockBlueprint-ve5 ""Custom RSS/Atom feed""-Custom RSS/Atom feed-Custom RSS/Atom feed: java.lang.NoClassDefFoundError: Could not initialize class com.sun.syndication.feed.synd.SyndFeedImpl"
2017-07-05T08:31:37Z,BBC News,Warning,Update & Save BBC News,Action completed successfully with warnings
2017-07-05T08:31:37Z,BBC News,Ended,,

Does anyone know of a reason why this would fail under scheduler when it works OK during setup? The Visokio Enterprise service is running under my name and license number. I've also tested the file OK in the desktop software installed on another machine with a different license.

OmniscopeX.exe was blocked by AntiVirus.

naruemon — Tue, 04 Jul 2017 03:22:35 -0400

I tested version 3.0 (Omniscope 3.0 Alpha b7938 for Windows). When I started Omniscope, Antivirus (AVG) always blocked the program to start and reported as a threats. Please find the attached file.

SSAS Cubes: support for Data Connector in 3.0?

AlexD — Wed, 28 Jun 2017 03:33:25 -0400

The present OLAP connector in Omniscope classic does not seem to be reliable, such as only being able to return a small number of dimensions and measures, requiring an entire refresh each time the source block is expanded and the selected dimensions and measures often appear to be deselected while the block is refreshing.

Most people in our organisation will reconcile their work to SSAS Cubes, and we have often needed to make workarounds to report the same data, such as replicating the Cube from the underling Warehouse. This creates heartbreaking duplication of logic and exposes us to the risk of missing out logic built between the Warehouse and Cube.

It would be good to know if SSAS Cubes will be a supported connector in Omniscope 3.0.

Thanks

New: Connectors-iGeolise Travel Time (2.9+)

richard — Tue, 28 Jan 2014 11:29:53 -0500

In Omniscope 2.9 (b820+) we have added an iGeolise Travel Time connector. This connector is available as an operation in DataManager and contains three services:

Time Maps

Create isochrone shapes showing the area around an origin which can be reached in a given time period and using a specified mode of transport.
Routing

Retrieve directions for your journeys. Configurable options include the start or arrival date/time and a mode of transport,
Rank Points

Upload a collection of origin and destination points along with a mode of transport and maximum journey time. Travel Time will return only the destinations which can be reached in the given time period along with the distance and time taken to reach the location.

The DataManager block contains a link to iGeolise Travel Time's sign up page where you can create an account.

Please let us know if you encounter any problems or have any questions.

Category field data type consistency

bernardpi — Mon, 19 Jun 2017 12:53:43 -0400

Under what conditions does a field qualify as a "category" field data type?

We are testing some reports against multiple data sets with the same structure (same fields) but different data points and believed that the "category" field data type applied to fields with a certain number of discrete text values (under 500?) - however, we are finding inconsistencies in the way these are interpreted with some fields being read as data type text and others data type category. We are querying from an ingres database if that helps.

Is there a way to guarantee the output data type value that then ultimately drives that type the filter is? Like some rules to follow? (Selectable options as opposed to text search boxes). We are finding that selecting category data type on the field is not enough if the data points underneath change.

Thanks for your help in advance

Data Manager: Dates coming out wrong in a csv

JohnMR — Fri, 16 Jun 2017 09:58:03 -0400

Hi all,
I've created a file that has dates info. When I pull the dates in the UK format (dd/MM/yyyy) everything is fine but if I use the field organiser to change to US format (MM/dd/yyyy) the csv date column is half in dates (if you use show formula it's a number like 42045) but half is no dates (if you go to show formulas it's 02/10/2015). Why is this happening? It doesn't happen if I use UK dates.
Thanks,
John.

Data sources: Saving XML Custom Mapping 'Template'??

Jamie_Lambert — Fri, 02 Jun 2017 05:51:35 -0400

I’ve got a data block in Omniscope looking at a URL query in xml, and I'm wondering if there's a way to save a custom mapping layout as a 'template', or something similar.

Every day we run this API and some days map fine, but other days Omniscope struggles to correctly parse the results and omits columns of data that we need. I think this is probably because the URL query changes slightly each day- it’s not one, set URL because part of the URL changes with a daily “job ID” code. The data / response is in the exact same layout day to day. We’ve experimented with unticking the auto-recognise options under Parsing and haven’t yet found a combination that consistently works across different daily queries.

We can go in and edit the custom mapping to re-tell Omniscope how to correctly lay out the data, but are hoping there’s a way to ‘save’ these settings to work across daily requests rather than having them erased each time a new URL is entered and having to manually tick the checkboxes for row, column etc. So, essentially, my question is; Can we save our custom mapping layout as a template to apply across URL queries which, although they technically change daily, are all consistent in layout?

Data Discordance caused by Google Analytics API

CarenaLi — Fri, 16 Jun 2017 04:57:49 -0400

Hi all,

Thanks for reading this and hope you are well.

Recently we have experienced data discordance between the numbers pulled through Omniscope and the actual ones showing on Google Analytics.

Does anyone have the same issue?

Many thanks!

Map View: Custom logos instead of markers

yllau — Wed, 14 Jun 2017 08:42:24 -0400

At this moment, we can customise the markers to replace them with different shapes, as per image (pre-set)

Suggest to have a customs logo instead of markers in the next release.

Data Sources: BigQuery connector in and out

costart — Fri, 09 Jun 2017 05:30:45 -0400

Hi,
I often use omniscope to help build my reports but I am often using Bigquery to store my data. Be great to add it in.

Cheers,
Robert