Support

Formulae: Dynamic/evaluated reference to a formula in a field?

fcavalieri — Wed, 29 Oct 2014 09:18:23 -0400

Hi,
I'd like to know if it is possible, in a formula field i.e. [Cost_Formula],
to refer to and run a specified formula contained in another text field i.e. [Formula].

I attach a file for example (the exact result I'd like to obtain is the same of Cost field).

Thanks, Franci

New: Sources-MongoDB Database Connector

bfromson1 — Mon, 10 Mar 2014 07:22:35 -0400

There is growing interest in noSQL databases in our organisation, and specifically MongoDB.

Would be useful if Omniscope could hook directly to the data stored in MongoDB repositories...

Anyone else interested?

https://www.mongodb.org/

Connectors: Google Analytics API definitions

panost — Tue, 21 Oct 2014 11:37:57 -0400

Hello,

I have a minor bug to bring to your attention, the "In-market Segment" in the Google Analytics API is declared as "ga:interestMarketCategory" (see attached screenshot), when the correct definition is "ga:interestInMarketCategory"

https://developers.google.com/analytics/devguides/reporting/core/dimsmets#cats=audience

This is quite insignificant as I barely ever need it, but it would be nice if it could be corrected.
I am using the latest 2.9 b1474 (15/10/2014).

On another note, you might be interested in Google's MetadataAPI which provides always up-to-date definitions of columns:
https://developers.google.com/analytics/devguides/reporting/metadata/v3/
not sure if you can build it into Omniscope but it might make things easier between versions!

Also lastly I was wondering if in cases such as this it is possible to build manual patches into connectors, perhaps by editing config files or is there/will there be such developer functionality for connectors?

Many thanks in advance,
Panos

Filtering: Category field in Desktop shows as Text field in (Web Start) Viewer?

Alexander — Mon, 20 Oct 2014 14:15:08 -0400

Hi all,

We publish a dashboard to one of our clients using a template that we save elsewhere using the Scheduler. In the file action we have the following steps:
- Refresh from source
- Unlink from source
- Save IOK

In the source file the field is a Category type. In the template the field is also a Category field.
After the Scheduler action I opened the saved IOK file, and the field is (as expected) a Category field.

However if we deploy the same file using Web Start, the Java free Viewer opens to show the field as a Text field with an "search text" filter option.

This behaviour seems to be new, but I am not sure since when. How can we show this field as a Category filter even when we deploy in free Viewer using Java Web Start?

Please advise. Thanks

Regards!
Alexander

Outputs: Warning with PDF Output?

Mees — Mon, 06 Oct 2014 08:13:17 -0400

Hi, can you please help us in understanding the attached warning in a PDF output?
The document is published, but with a warning.

Thanks

Linux Headless Server/Scheduler - Unable to read data from database

Veaceslav — Wed, 01 Oct 2014 14:04:01 -0400

This post describes how to check and fix Unable to read data from database errors on a headless Omniscope server or scheduler running on Linux.

If you can run Omniscope Desktop on your machine, you don't need to follow these instructions. Instead, you should run Omniscope Desktop, open your file, go to Data Manager and expand your database block. A dialog should be displayed asking you to locate your database driver. Select the jar file, re-load your data and save the file.

Note: Database (jar file) drivers should be downloaded from the official website distributing the driver.

If you cannot run Omniscope Desktop on your machine to configure the driver from the UI (e.g. you have a headless Linux machine) then you should follow the next steps:

1. Check whether you need to specify a driver location

If you already know that the driver location is wrong or missing, go to step 2.
If you get only 'Error Unable to read data from database' without any additional details, you need to check whether the driver location is the root cause of the problem.

a. Edit {OMNISCOPE_INSTALL_DIR}/_launch.sh
```
    {OMNISCOPE_INSTALL_DIR} is the directory where Omniscope is installed
```
Change JAVA_VM_PARS property to include both AppSetting_APPSETTING_REPORT_RECOGNISED_ERRORS_AS_BUGS and AppSetting_APPSETTING_REPORT_DATABASE_ERRORS_AS_BUG, leave all other JVM flags unchanged.

E.g.
JAVA_VM_PARS='-Xms64M -Xmx1100m -XX:MaxPermSize=128M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=50 -XX:NewRatio=8 -XX:+UseG1GC -DAppSetting_APPSETTING_REPORT_RECOGNISED_ERRORS_AS_BUGS=true -DAppSetting_APPSETTING_REPORT_DATABASE_ERRORS_AS_BUGS=true'

b. Run your tasks again
At this point you should get more details about the error and it should look like this:

...driver JAR file location not specified. Please reconfigure this legacy file's database connection in the desktop application.

2. Configure Omniscope to use a specific driver
My example shows how to configure Omniscope to use a MySQL driver. Other database types are very similar.

Download MySQL JDBC driver from MySQL website.
E.g. http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.33.zip
Unzip, get the jar file and put it somewhere on the machine running Omniscope scheduler
E.g. /home/visokio/visokio-omniscope-2.9-b1200/lib/mysql-connector-java-5.1.33-bin.jar
Edit {OMNISCOPE_INSTALL_DIR}/_launch.sh again
Modify JAVA_VM_PARS property to include the JDBC driver location and remove the flags added at step 1.(a)
E.g.
JAVA_VM_PARS='-Xms64M -Xmx1100m -XX:MaxPermSize=128M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=50 -XX:NewRatio=8 -XX:+UseG1GC -DMySqlDriverSearch_driverDir=/home/visokio/visokio-omniscope-b620/lib/mysql-connector-java-5.1.33-bin.jar'

Note: Here are property names for the other databases (make sure you prepend a '-D' in front of the property e.g -DMySqlDriverSearch_driverDir):

IngresSqlDriverSearch_driverDir
MySqlDriverSearch_driverDir
OracleThinDriverSearch_jarFile
PostgreSqlDriverSearch_driverDir
SqlServer2008DriverSearch_jarFile

These steps configured Omniscope scheduler/server to locate and use database drivers when running in headless mode.

Note: If you configure your file on one machine, then use it on another machine, the driver needs to be added manually on the second machine, otherwise you will get the 'Unable to read data from database' error.

Bar/Line View: Missing X axis values?

martingurner — Tue, 30 Sep 2014 11:05:13 -0400

Created a Line Chart based on many series, filtered out by device. Had noticed when a series starts on a later time line, the x axis does not show values until the second series timeline starts.

See attached file. Is there a setting causing this?

Have selected Chart, changed the measure to be median and type line, split by date and layered and coloured by series. Tiled by another attribute in the series.

This affect appears when the graph is tiled, even if the data is of the same tile attribute. If the tile option is removed, the axis return to normal and show as expected.

Outputs: Publishing to Excel 2003 - fonts issue?

Barcl — Thu, 19 Dec 2013 10:53:11 -0500

Omniscope Server 2.8 b1185
Microsoft Windows Server 2003 R2 - Server Pack 2
Microsoft Office Excel 2003 (11.8169.8172) SP3

Can you suggest what to do to resume working?

Thanks

Markers displaced on Mobile Map

DominicChan — Thu, 25 Sep 2014 06:10:53 -0400

Hi

Sometimes, the markers on the Map via Mobile view are displaced. I say sometimes because it occasionally miraculously fixes itself. Since releasing the report to my team a few people also experienced the same issue.

Would you happen to know the cause of this?

Dom

Content View: Using Variables for resolving tab links?

tagarw — Wed, 13 Aug 2014 01:59:06 -0400

Suppose in a report I have 5 tabs. In Tab 1 I have one Variable with 10 possible values. If I select any one of these 10 values, then I want the file should switch automatically to say, Tab 4. Can we create such links between two tabs of same report? Please confirm.

Thanks

Tile View: Image display options?

Harry — Wed, 17 Sep 2014 09:34:38 -0400

When using images in the tile view my images, due to them being rectangular and on a white background, can appear far smaller than their tile. Is it possible to have borders surrounding your tiles or rotate your images 90 degrees to fit the tile better?

Filtering: Re-ranking filtered data sets?

abhishekdas1989 — Fri, 05 Sep 2014 06:16:58 -0400

Hi,

I have a medium sized data set ~2500 records. My filter is a checkbox filter (I can select any number of records, filter field is non-repeating text). The idea here is to make this filtered data a subset as I want to perform some operations on this filtered data.

The end goal is to assign a rank to each record of this randomly selected subset of data. So, if an additioal record is selected, the ranks may change based on the field value of the new record.

Formulae: Filtering top 10% of subset

abhishekdas1989 — Thu, 04 Sep 2014 04:14:52 -0400

Hi,

I intend to perform some basic calculations (mean) on a subset of the records in a table. I used Subset_Mean(field name, RowIndexSubset). However, it returns a null value. The RowIndexSubset is calculated properly (verified it using Subset_UniqueCount).

The main idea is to get the top 10% of the total records and then calculate the mean of the values in a specific field. This total records will change based on a filter selection (this filtering is working fine).

Security: Connecting via Proxy Server requiring Authentication.

antonio — Mon, 18 Jun 2012 12:59:28 -0400

Sometimes users experience the following error while trying to open a file or importing a source from DataManager:

"HTTP/1.0 407 Proxy Authentication Required"

When you need to open a file on a remote server through a Proxy server that requires authentication, then you have to provide Omniscope with the Proxy server authentication credentials. To do this select
Settings > Advanced > Default Proxy Authentication
and insert username and password. These credentials will be valid for the whole Omniscope session.

Note that proxy server authentication is different from remote server authentication. If the remote server requires authentication then you will receive the following message:

Unauthorised (HTTP error 401)

To resolve this, depending on the dialog, tick "Requires authentication" and insert the username and password.

Formulae: Rolling (dynamic) moving average

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

Rolling (dynamic) average function that accommodates multivariate conditions (last 52-week average)

Display: Manage fields: User-selected numeric abbreviations?

nevynb — Mon, 11 Feb 2013 11:21:00 -0500

Hi Guys - Any confirmed timelines on when I will be able to change 'G' to 'B' for billions?
This causes confusion from my users. - Thanks

Aggregation: Calculating weighted means?

Alexander — Fri, 15 Aug 2014 08:40:24 -0400

Hi All,

I am encountering a problem that I am aggregating a rather large dataset, but I am not able to choose a weight for the fields that I want to result as the average of the aggregated data.

Do you get what I mean?

The same problem is occuring as discussed in http://forums.visokio.com/discussion/2606/aggregation-why-are-some-fields-not-editables.

Please advise.

(Using custom build: Hotfix Function not supported 2.8 b 1276)

Graph view: ability to break axes?

rng — Wed, 13 Aug 2014 09:52:00 -0400

Is there a way to break axis on a Graph view? This is to compress the scale & hide empty section on the plot...

In my case I have year/date dimension plotted on x-axis. The dataset has few data-points corresponding to year 1900 (this is due to config set on the source system), while the remainder/majority are around current date.
So the resultant view has markers plotted on the edges while the major portion in the middle sectrion is left blank.

Thanks!

Ranking: Sorting based on variables?

tagarw — Fri, 08 Aug 2014 03:41:06 -0400

Can we customise the sorting operation in Omniscope. For example: I have a table with two columns/fields [empname] and [salary] and a Variable allowing the user to select between these two column names. For example, if user selects 'empname' as Variable value, data in table should be sorted by 'empname', and if user selects 'salary' as Variable value, then data in table should be sorted by salary.

See attachment for reference.

Thanks..

Formulae: Subset Functions-Record count within lookback window/ Records between

alexandervolk — Mon, 11 Aug 2014 05:31:16 -0400

I have a set of timestamped data (page visits) in which - for each record - I want to calculate the number of page visits within the last N minutes. I have a device which sets N as a parameter, defaulted to 5 minutes.

In a second field next to "timestamp", I am calculating "timestamp-N" for the lookback window. My initial idea was to use the RECORDCOUNT formula and for each record, calculate the record count between MIN[timestamp-N] and MAX[timestamp]. That doesn't seem to work ...or at least I can't get the formula right.

Are there other ways to get the results I need?

Thanks for your help!
Alex

Workflow: Passing values between tabs/files?

tagarw — Thu, 07 Aug 2014 06:39:18 -0400

Hi All,

Can two Omniscope tabs communicate with each other? For example in Tab 1 we are selecting some value and we want to retrieve that value in Tab 2. Can we do that? If yes... how?? Please confirm.

Thanks..

Formulae: Moving averages for daily data?

nash — Wed, 23 Jul 2014 03:33:59 -0400

My data have KPIs on a daily basis for every day of the week.

I would like to calculate the average of the KPIs for 3, 7, 10, 14 days from the starting date in the data.

Thanks.

Date/Time: Detecting Year as Date/Time w/o thousand separators?

chrisamott — Fri, 23 Apr 2010 14:24:48 -0400

When using the DATEUNIT function to determine the year of a date, by default the result is displayed as an Integer number with thousand separators. Using Data > Manage Fields, we can reformat to remove the separators if we needed a plain integer displayed.

However, when using DATEUNIT as part of a larger function, to create a string YEAR + "Quarter 2" for example, the thousand separator cannot be so removed and the result, '2,009 Quarter 2' is far less preferable than '2009 Quarter 2'.

Can this be resolved?

Pivot View: View data exported to Excel?

Avizua — Mon, 04 Aug 2014 03:55:11 -0400

Many users ask to export the result of a pivot view in Excel. Currently, the export to Excel gives the equivalent of a Table view.

Thanks, Magali

Layout: Arranging Views to always have equal width/height?

alexandervolk — Thu, 31 Jul 2014 04:29:56 -0400

When I have say, two rows of four Table views on a page, is there a way of arranging them in such a way that they always preserve their RELATIVE width and height to each other?

Currently, when viewing the page on different screen sizes, there is no telling how the Viewer will resize the Table views. No matter how I arrange them on my machine, on any other screen they will appear misalligned, often to the point of illegibility.

Thanks for any help!

Connectors: Omniscope & AppNexus?

beck — Wed, 30 Jul 2014 12:37:02 -0400

How to make works a conversion pixel without a relation with a banner or an advert, and then make it work together a segment pixel too? in app nexus?

Disabling mouse wheel zoom when hovering over line view

edtclarke — Wed, 30 Jul 2014 06:38:43 -0400

Does anyone know if you can disable the zooming of a line view when hovering over a view and then using your mouse wheel. I'm sure 2.7 didn't do this but 2.8 seems to.

Thanks in advance

Scheduler: Pause & Stop buttons not working?

edtclarke — Tue, 25 Mar 2014 07:47:04 -0400

Hi,

I'm just testing multiple Schedulers in 2.8 b1235 on our dev machine and have got everything working but I've noticed that the 'Pause Scheduler' tick box does not appear to actually pause the Scheduler nor does the 'Stop' button actually stop the Scheduler?

Am I missing something or are you guys aware of this?

Thanks, Ed

Styling: Customising Sidebar devices?

alexandervolk — Thu, 24 Jul 2014 10:12:23 -0400

Hello,

We're trying to adapt as much of our company's CI into our Omniscope dashboards. It's working great so far except for devices. If there's an option to change font face, size and color for filter devices in the right sidebar or otherwise style them, I seem to have missed it.

Can anyone let me know if that is even possible?

Thanks!

Connectors: Querying API's?

acdewinter — Tue, 29 Jul 2014 02:28:57 -0400

Hi Visokio,

I have a random question, is there perhaps a way for Omniscope to connect to public/private API's and pull data that way, or is the complexity of how API's operate in general out of scope?

Regards
Adrian