Support
http://forums.visokio.com/categories/support/p2/feed.rss
Mon, 30 Oct 17 11:59:47 -0400Supporten-CAIssue 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 -0400bernardpi3177@/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 -0400Phillipa3160@/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 -0400junrong3164@/discussionsThe 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 -0400Phill3155@/discussionsAny 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 -0400aknotts3159@/discussionsSource 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 -0400Jamie_Lambert3157@/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 -0400DCC_simon3150@/discussionsI'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 -0400edblake3148@/discussionsContent 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 -0400bernardpi3124@/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 -0400bernardpi3147@/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 -0400Mees3141@/discussionsIn 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 -0400daniel3130@/discussions All I am doing is trying to create a rate field of:
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 -0400Mees3129@/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 -0400MPatel3126@/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 -0400MPatel3127@/discussionsI 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 -0400Avizua3119@/discussionsSQL Store Procedures from content view
http://forums.visokio.com/discussion/3114/sql-store-procedures-from-content-view
Fri, 08 Apr 2016 05:46:01 -0400enrico683114@/discussionsIn 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 -0400daniel3113@/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.
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 -0400DominicChan2711@/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.
However, it doesn't refresh. I have looked through some of the previous threads in the forum and applied the settings as discussed.
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 -0400steve3109@/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.
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.
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 -0500dabay3105@/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.
]]>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 -0500dabay3106@/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. ]]>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 -0500acohen3100@/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 -0500CRead3099@/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 -0500Alexander3077@/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 -0500nevynb2030@/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 -0500enrico683044@/discussionsThe 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 -0400dvo_D440@/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 -0500JamesPC3049@/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 -0500Phillipa3042@/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.