Support

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

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

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

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

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

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

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

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

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

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

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

Thanks]]>

Tile View: Image display options?

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

Filtering: Re-ranking filtered data sets?

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

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

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

"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

]]>

Display: Manage fields: User-selected numeric abbreviations?

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

This causes confusion from my users. - Thanks]]>

Aggregation: Calculating weighted means?

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

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

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

See attachment for reference.

Thanks..]]>

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

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

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

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

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

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

Thanks, Magali]]>

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

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

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

Disabling mouse wheel zoom when hovering over line view

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

Thanks in advance]]>

Scheduler: Pause & Stop buttons not working?

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

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

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

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]]>