Support http://forums.visokio.com/categories/support/p2/feed.rss Mon, 30 Oct 17 11:59:47 -0400 Support en-CA Issue with Ingres/Vector database blocks in omniscope server 2.9 b1835 http://forums.visokio.com/discussion/3177/issue-with-ingresvector-database-blocks-in-omniscope-server-2.9-b1835 Wed, 28 Sep 2016 12:34:13 -0400 bernardpi 3177@/discussions
However, when we use omniscope server to refresh our reports that contain these database blocks (using XML scheduler files), the reports are refreshed but the field names have lost their proper case even though the file has been saved with 'Auto-correct field name case' option selected.

If the datamanager has other blocks below (merge joins, aggregates etc) this ends up affecting their ability to work as before (the merge joins will no longer work or work in an erroneous way).

I have raised a bug against this and have included a cut down example in the report but I'm not sure what use it will be as you won't be able to refresh this database block externally.

Please advise.]]>
Comparing Date values: Filtering dates after 2014 http://forums.visokio.com/discussion/3160/comparing-date-values-filtering-dates-after-2014 Wed, 03 Aug 2016 05:54:58 -0400 Phillipa 3160@/discussions
I am totally new to dates in Omniscope and would like to know how to select dates post 2014.

I have a field in date format dd.MM.yyyy HH:mm:ss and want to select records that are only after 2014.

I know it is not rocket science but as a beginner I need some help.

Thanks.
Phillipa]]>
Branding: "branding.internal" folder and how to customize html file http://forums.visokio.com/discussion/3164/branding-branding.internal-folder-and-how-to-customize-html-file Tue, 16 Aug 2016 10:55:05 -0400 junrong 3164@/discussions The way we work is: we installed the Omniscope server and it has the mobile sharing folder where we put all *.iok files in.
We can view all sub-folder and IOK applications from browser by typing the link of this server.

Where is the branding folder? Can we modify the branding html/css files to customize the look of web page?]]>
Logistics File Extension .ilf http://forums.visokio.com/discussion/3155/logistics-file-extension-.ilf Thu, 28 Jul 2016 09:27:25 -0400 Phill 3155@/discussions Any ideas on what the problem could be or what kind of file this is..?
Thanks in advance!]]>
Text tools "Any" not working in device view http://forums.visokio.com/discussion/3159/text-tools-any-not-working-in-device-view Tue, 02 Aug 2016 09:11:55 -0400 aknotts 3159@/discussions Source Field as with Batch Append from Data file source http://forums.visokio.com/discussion/3157/source-field-as-with-batch-append-from-data-file-source Fri, 29 Jul 2016 09:46:21 -0400 Jamie_Lambert 3157@/discussions
I've just started using Omniscope and anticipate this being an embarrassingly easy answer, but still here goes; is there a way to add a field effectively the same as the Source Field from Batch Append, but for a single Data file source?

Reason being I'm setting up a flow that starts with a file whose filename contains a date which I'd later like to have as a value. Easily made automated with Batch append data source but not individual files. Any suggestions?

Many Thanks]]>
RAM usage limit http://forums.visokio.com/discussion/3150/ram-usage-limit Thu, 14 Jul 2016 08:41:07 -0400 DCC_simon 3150@/discussions I've been working on omniscope version 2.8 b1185 and for some reason the program has now limited itself to 0.5GB of RAM. I'm the only user of our program and machine is there a way to force omniscope to use all the available RAM on the machine.

would updating to 2.9 fix this and force omniscope to recheck the available RAM?

thanks

Simon
]]>
File Ouput: csv Line Endings http://forums.visokio.com/discussion/3148/file-ouput-csv-line-endings Tue, 12 Jul 2016 05:04:27 -0400 edblake 3148@/discussions Content views not loading in PDF Batch Output http://forums.visokio.com/discussion/3124/content-views-not-loading-in-pdf-batch-output Mon, 09 May 2016 04:25:34 -0400 bernardpi 3124@/discussions
Is there something I can do to ensure that when these screenshots of the report are being taken that it waits for all views to load? It's not consistently the same views either. I can share the report/omni file it has produced privately if necessary.]]>
Bar/Line View: Orientation of Bar View Category Labels on the X-Axis in browser mode http://forums.visokio.com/discussion/3147/barline-view-orientation-of-bar-view-category-labels-on-the-x-axis-in-browser-mode Thu, 30 Jun 2016 04:49:35 -0400 bernardpi 3147@/discussions
Why does the orientation of the labels in the Bar View appear correctly in the Desktop Version (Horizontally) but then render vertically in the Mobile Version of the Report? I can't find a setting in the Bar View which seems to correct this.

Thanks]]>
Bar/Line view: Removing Measure Label on the Y axis http://forums.visokio.com/discussion/3141/barline-view-removing-measure-label-on-the-y-axis Mon, 20 Jun 2016 09:48:14 -0400 Mees 3141@/discussions In the bar chart we use a double split. See attached.
We need to get rid of the label on the left but keep the same value as a title.
How can we do this?
Thanks
Arjan]]>
Formula field: Omniscope Freezes with subset_uniquecount http://forums.visokio.com/discussion/3130/formula-field-omniscope-freezes-with-subset_uniquecount Mon, 23 May 2016 10:50:30 -0400 daniel 3130@/discussions
All I am doing is trying to create a rate field of:

Subset_sum([Dementia Register])/Subset_uniquecount([Practice Code])



Version 2.9 b1823 on a Win 10 desktop and also tested on a win 10 laptop. Problem persists in both.

]]>
BCG Matrix http://forums.visokio.com/discussion/3129/bcg-matrix Fri, 20 May 2016 10:40:31 -0400 Mees 3129@/discussions
We try to create a BCG matrix.
It needs an x-axis that has zero on the right and ascending numbers to the left.
Is this possible in Omniscope?

I have attached an example

Many thanks
Arjan]]>
Subset formulas - calculating % of Total per category http://forums.visokio.com/discussion/3126/subset-formulas-calculating-of-total-per-category Thu, 12 May 2016 11:34:25 -0400 MPatel 3126@/discussions
I have survey data and i want to show data by the percentage of control and exposed respondents. The data is categorical.

Column A; Column B; Column C
Respondent 1 ; Control; Competitor A
Respondent 2 ; Control; Competitor B
Respondent 3 ; Exposed; Competitor C
Respondent 4 ; Exposed; Competitor A
Respondent 5 ; Exposed; Competitor B
Respondent 6 ; Exposed; Competitor C

The chart needs to show two bars for Competitor A, one control and one exposed. Control would be 50%, Exposed would be 25%. For competitor B it would show Control 50%, Exposed 25%. For competitor C it would show Control 0%, Exposed 50%.

Any idea how to do this??]]>
Time Series Growth Calculation - Getting Incremental Numbers from Cumulative Total http://forums.visokio.com/discussion/3127/time-series-growth-calculation-getting-incremental-numbers-from-cumulative-total Thu, 12 May 2016 17:53:16 -0400 MPatel 3127@/discussions I have data that's coming in cumulatively:

Date | # of Participants
4/1/2016 | 400
4/2/2016 | 500
4/3/2016 | 625

I want a field that will calculate the difference from the day before. So for 4/2/2016, it would show 100 (500-400). For 4/3/2016 it would show 125 (625-500). Please let me know what formula to use. Thanks!]]>
ORACLE fields description http://forums.visokio.com/discussion/3119/oracle-fields-description Tue, 19 Apr 2016 06:01:28 -0400 Avizua 3119@/discussions SQL Store Procedures from content view http://forums.visokio.com/discussion/3114/sql-store-procedures-from-content-view Fri, 08 Apr 2016 05:46:01 -0400 enrico68 3114@/discussions In case, where can I find an example?]]> How to configure database connector for Actian Vector? http://forums.visokio.com/discussion/3113/how-to-configure-database-connector-for-actian-vectors Thu, 07 Apr 2016 12:31:46 -0400 daniel 3113@/discussions
I've just installed Actian Vector and uploaded a csv data set into a new database table I setup in Actian Director.


Now in Omniscope I want to access that database table, so just used the Database table.

In the Database table connector block I selected Vectorwise, an error tells me to get a jdbc file.

I have found the jdbc Version 4.2.0 from Actian at http://esd.actian.com/product/drivers (is this the correct one?)

Unzipped this file into my documents and pointed the connector to that jar file.
I filled in the Host name, database name default port was VW7 as well as a default username in actian.


I'm not sure what steps I am missing but this doesn't seem enough and I just get an error in connecting to the database.





]]>
Refresh: Mobile Viewer not refreshing? http://forums.visokio.com/discussion/2711/refresh-mobile-viewer-not-refreshings Thu, 11 Sep 2014 05:52:57 -0400 DominicChan 2711@/discussions
I have an IOK file, created and saved using our fully licensed server, aimed to be viewed on a mobile phone, set to refresh automatically, where the data feed is just a iok output which is refreshed and saved down every 15minutes.

image

However, it doesn't refresh. I have looked through some of the previous threads in the forum and applied the settings as discussed.

image

Am I doing something wrong, please advise if there are other steps I need to take?

Thanks]]>
Windows 10 upgrade, and Omniscope locale settings http://forums.visokio.com/discussion/3109/windows-10-upgrade-and-omniscope-locale-settings Tue, 15 Mar 2016 11:59:07 -0400 steve 3109@/discussions
For example, if in France, you may find number/date formats start getting displayed in English.

You can resolve this in several ways:

1. Change the Windows language.

Go to Control Panel > Clock, Language and Region > Language.
Add the desired language, downloading any language packs as needed.
Move up to configure as default.
Regional settings will follow suit automatically.

2. Alternatively, change regional settings directly.

Go to Control Panel > Clock, Language and Region > Change date, time or number formats.
Under "Format", change "Match Windows display language (recommended)" to the locale you want.

3. Alternatively, change Omniscope's settings directly.

Start Omniscope and open the Settings menu. Change the "Interface language" and "Data locale" as needed. Restart if prompted.
This will apply regardless of which IOK file you have open. (However, note that timezone settings are per-file).
]]>
Pivot view: Sorting Column Headers in descending date order http://forums.visokio.com/discussion/3105/pivot-view-sorting-column-headers-in-descending-date-order Mon, 07 Mar 2016 06:39:47 -0500 dabay 3105@/discussions
I have a pivot view that has the date columns along the x-axis, is there a way to sort the columns in descending order so the latest date appears as the left most column. Below is the screenshot of the original report where it only orders the dates in ascending order.

image]]>
Table View: Lock displayed fields to prevent new fields from appearing in the existing tables http://forums.visokio.com/discussion/3106/table-view-lock-displayed-fields-to-prevent-new-fields-from-appearing-in-the-existing-tables Mon, 07 Mar 2016 12:30:14 -0500 dabay 3106@/discussions
Is there a way to lock the displayed fields for each existing table view, so if you add extra fields to the Omniscope block in the data manager tab it does not mess up your existing tables? e.g. see screenshot below where the extra columns appear appended to the table which is undesirable.
image]]>
Mobile: Browser versions-user session timeout? http://forums.visokio.com/discussion/3100/mobile-browser-versions-user-session-timeouts Fri, 26 Feb 2016 09:26:49 -0500 acohen 3100@/discussions
Many thanks,
Ari]]>
Performance: Finding the bottleneck in hosted web display? http://forums.visokio.com/discussion/3099/performance-finding-the-bottleneck-in-hosted-web-displays Fri, 26 Feb 2016 09:11:30 -0500 CRead 3099@/discussions
This could obviously be Omniscope, the server, the internal network, the connection to my laptop, or my browser's rendering speed in theory, but I'm not having much luck in tying down what's causing it to run slowly.

Ideally, I'd like the file to load and run quickly over a wet string - the sort of thing you encounter with hotel / event / guest wifi. I've made it tiny already, and the libraries required on load are very small, so I'm not sure where to look next for optimisations.]]>
Scheduler: Refresh action skipping one of 3 sources? http://forums.visokio.com/discussion/3077/scheduler-refresh-action-skipping-one-of-3-sourcess Thu, 14 Jan 2016 07:12:31 -0500 Alexander 3077@/discussions
I was wondering whether anyone has experienced a similar situation, and what a solution might be.
Last night our scheduler performed a chain action. One of the tasks is a file action, (refresh and publish).

The file action has 3 main sources, combined in joins and append operations. The output only contained data from 2 of the 3 sources. When executed again this morning, the result was as expected containing data from all 3 sources.

This situation create a feeling of unstable processes, a feeling we desperately want to avoid ourselves but especially at the client side. ]]>
Map View: Online world maps just a blank? http://forums.visokio.com/discussion/2030/map-view-online-world-maps-just-a-blanks Fri, 01 Mar 2013 03:27:57 -0500 nevynb 2030@/discussions
Is it possible to use Google Maps instead?
]]>
Performance: Memory management on a virtual server http://forums.visokio.com/discussion/3044/performance-memory-management-on-a-virtual-server Fri, 27 Nov 2015 03:57:18 -0500 enrico68 3044@/discussions The operating system that manage the virtual machines on this physical server is VMWare 5.1 and Omniscope version is the 2.9 Server.

Since datasets we are elaborating are growing up in dimensions quite rapidly, we have now changed the configuration in a way that the virtual memory used can be extended up to 32Gb and the number of virtual processors can be extended up to 8, if these resources are available (not used by other virtual machines) on the physical server where the virtual machine is installed.

We are now running some large .iok file update for testing the new server configuration, but till now Omniscope has always used at most the usual 16Gb of memory and, sincerly, I do not think that the problem is that there are no other resource available.

I'd like to know if there is a particular set up to perform to let Omniscope see and use the new available memory and processors or if anyone has experience to share about using Omniscope on virtual server.]]>
Idea: Mapping: German postcode zones (1-dig, 2-dig) available? http://forums.visokio.com/discussion/440/idea-mapping-german-postcode-zones-1-dig-2-dig-availables Thu, 07 Oct 2010 14:01:41 -0400 dvo_D 440@/discussions -> any idea?
Caution: attached postzone map might not be free, it's googled...]]>
Scheduler Error: extra sheet exists when it opens the Excel file? http://forums.visokio.com/discussion/3049/scheduler-error-extra-sheet-exists-when-it-opens-the-excel-files Fri, 04 Dec 2015 09:17:55 -0500 JamesPC 3049@/discussions
Chain action "omniscope" failure:
Error publishing block "Data file output 2"
com.visokio.util.jy: Error publishing block "Data file output 2"
at com.visokio.ent.actions.files.PublishDataManagerOutputBlocks.a(PublishDataManagerOutputBlocks.java:47)
at com.visokio.ent.actions.FileAction.a(FileAction.java:34)
at com.visokio.ent.actions.ChainAction.a(ChainAction.java:20)
at com.visokio.ent.actions.ChainAction.a(ChainAction.java:40)
at com.visokio.ent.actions.f.v(f.java:5)
at com.visokio.ent.actions.f.i(f.java:4)
at com.visokio.util.ut.run(ut.java:3)
at com.visokio.mxc.a(mxc.java:1)
at com.visokio.util.sy.a(sy.java:65)
at com.visokio.util.sy.a(sy.java:241)
at com.visokio.util.go.r(go.java:56)
at com.visokio.util.ph.s(ph.java:5)
at com.visokio.util.mh.o(mh.java:56)
at com.visokio.util.lh.l(lh.java:4)
at com.visokio.util.lh.a(lh.java:93)
at com.visokio.util.y3.run(y3.java:3)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException: A part with the name '/xl/worksheets/sheet2.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12]
at org.apache.poi.openxml4j.opc.OPCPackage.createPart(OPCPackage.java:777)
at org.apache.poi.openxml4j.opc.OPCPackage.createPart(OPCPackage.java:741)
at org.apache.poi.POIXMLDocumentPart.createRelationship(POIXMLDocumentPart.java:373)
at org.apache.poi.POIXMLDocumentPart.createRelationship(POIXMLDocumentPart.java:357)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:661)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:81)
at com.visokio.ms.th.d(th.java:42)
at com.visokio.ms.rh.a(rh.java:131)
at com.visokio.ms.rh.a(rh.java:65)
at com.visokio.ms.li.a(li.java:13)
at com.visokio.tvb.b(tvb.java:1)
at com.visokio.svb.a(svb.java:42)
at com.visokio.util.res.l.g(l.java:115)
at com.visokio.util.res.l.(l.java:145)
at com.visokio.svb.c(svb.java:29)
at com.visokio.svb.a(svb.java:57)
at com.visokio.svb.b(svb.java:34)
at com.visokio.svb.a(svb.java:31)
at com.visokio.mff.a(mff.java:28)
at com.visokio.mff.a(mff.java:14)
at com.visokio.mff.a(mff.java:7)
at com.visokio.lpd.a(lpd.java:147)
at com.visokio.lpd.a(lpd.java:144)
at com.visokio.amd.b(amd.java:22)
at com.visokio.zld.a(zld.java:23)
at com.visokio.datamanager.c6.run(c6.java:9)
at com.visokio.mxc.a(mxc.java:1)
at com.visokio.util.sy.a(sy.java:28)
at com.visokio.util.sy.a(sy.java:123)
at com.visokio.datamanager.hmb.a(hmb.java:79)
at com.visokio.ent.actions.files.PublishDataManagerOutputBlocks.a(PublishDataManagerOutputBlocks.java:29)
... 18 more

any ideas?]]>
Import: Unable to use Excel to read data http://forums.visokio.com/discussion/3042/import-unable-to-use-excel-to-read-data Wed, 25 Nov 2015 08:50:57 -0500 Phillipa 3042@/discussions
I have just opened a Omniscope IOK file which loads an xlsx file into Omniscope.
I last worked on it a month ago and everything was fine. Now when I go in I get an error message:

Unable to use Excel to read data. Using Omniscope reader instead.

Can anyone help with this?
Phillipa
]]>