Support
http://forums.visokio.com/categories/support/p5/feed.rss
Mon, 30 Oct 17 12:00:01 -0400Supporten-CAOutputs: Excel file open in another application?
http://forums.visokio.com/discussion/2820/outputs-excel-file-open-in-another-applications
Mon, 19 Jan 2015 11:03:27 -0500alex7thompson2820@/discussions Please can I get some assistance.
]]>Import: SQL view as a parameter in DataManager?
http://forums.visokio.com/discussion/2823/import-sql-view-as-a-parameter-in-datamanagers
Wed, 21 Jan 2015 07:04:24 -0500carlosmartinmari2823@/discussions I'm trying to introduce a parameter, say "Sqlview" that is being used in the DataManager database source block to call a custom SQL view as follows:
select * from p = {{Sqlview}}
The problem we have is that when you give the variable type to the parameter and set it as text, in DM the variable is automatically written as:
select * from "my_table_name"
which returns an error because it should look like that:
select * from `my_table_name`
Introducing the correct symbols doesn't help (parameter enter as "`my_table_name`").
Is there any way to do that?
Thank you in advance, Carlos]]>Outputs: PDF export with selectable text or followable URL?
http://forums.visokio.com/discussion/2806/outputs-pdf-export-with-selectable-text-or-followable-urls
Wed, 07 Jan 2015 07:52:41 -0500carlosmartinmari2806@/discussions I need to create for a client a report that includes followable URL adresses (I mean, that if the text says "http://foo.com/bar.html" the text is clickable as a link) or at least selectable text when arranged the data in a table view. Is that possible?
Best regards, Carlos]]>Filtering: Dynamic rankings in a filtered view?
http://forums.visokio.com/discussion/2821/filtering-dynamic-rankings-in-a-filtered-views
Wed, 21 Jan 2015 03:15:25 -0500nash2821@/discussionsAt the same time I need to calculate what is the share of the every of these three brands of all the brands which are selected. And the last requirement is to show the difference for every brand to the year before.
So far I work it out for all brand which are in the data with formulas in the fields. However I would need more dynamic.
Is there a way to get it are you working on it?]]>Export: Image Quality when copying views as screenshot images?
http://forums.visokio.com/discussion/2817/export-image-quality-when-copying-views-as-screenshot-imagess
Fri, 16 Jan 2015 04:01:26 -0500aknotts2817@/discussions I have tried maximising the view I am interested in so its the only view on the tab, then File > Export to PowerPoint, changing the Advanced settings to get a higher DPI... however, when I print it, it restores the view I maximised to its original size and prints all the views rather than just the one I want. (I hope that makes sense).
Thanks]]>Scheduler: PDF batch outputs - image retrieval & rendering time?
http://forums.visokio.com/discussion/2789/scheduler-pdf-batch-outputs-image-retrieval-rendering-times
Mon, 15 Dec 2014 15:10:45 -0500CRead2789@/discussions Is there any way to add a delay (or event wait) to allow the images to load, or alternatively, change the way I call them? I've tried adding them as an image directory, but that only allows for tile view, which doesn't suit my needs (I need to size them consistently using html).]]>Pie View: Splitting by top 10 and 'othering' all other measures?
http://forums.visokio.com/discussion/2808/pie-view-splitting-by-top-10-and-othering-all-other-measuress
Thu, 08 Jan 2015 08:00:41 -0500kmatrix9992808@/discussionsGoogle Analytics feed - User ID Web Tracking function
http://forums.visokio.com/discussion/2809/google-analytics-feed-user-id-web-tracking-function
Fri, 09 Jan 2015 10:34:34 -0500DominicChan2809@/discussions We have been using the Google feed for some high-level MI on our web traffic via Google Analytics.
I had a quick play around in the Omni Google feed block and couldn't find this functionality. First question is if this is something already available in Omniscope? Do you know of this function in GA and how Omniscope can be set up to utilise this UserID function?
I am getting a tech demo from our developers on Monday, so will get more info and functional understanding of the UserID functions/data extraction method in GA.
Thanks Dom ]]>Security: Authentication on Omniscope Web Server?
http://forums.visokio.com/discussion/2801/security-authentication-on-omniscope-web-servers
Thu, 25 Dec 2014 01:24:36 -0500stavro2801@/discussions How can I create an authentication page which will be shown when we click to mobile web server page? Also all users shouldn't access to all reports. Can you explain it detailed.]]>Versions: 'Omniscope Web Server' part of Scheduler not visible?
http://forums.visokio.com/discussion/2785/versions-omniscope-web-server-part-of-scheduler-not-visibles
Fri, 12 Dec 2014 07:41:34 -0500stavro2785@/discussions I noticed on the site that Omniscope Scheduler 2.9 has an option called 'Omniscope Web Server'. We are running version 2.9, but we can't see it on our Scheduler. What is the problem?
I am using the version: 2.9-beta b1342]]>Performance: Limiting max RAM usage per user account/instance?
http://forums.visokio.com/discussion/2784/performance-limiting-max-ram-usage-per-user-accountinstances
Fri, 12 Dec 2014 07:39:06 -0500stavro2784@/discussions Is there any way to limit the RAM usage of an Omniscope report? For example, I want to set that every Omniscope report will use max 7 GB RAM. The number of opened files doesn't matter.]]>Outputs: Text characters/format in emails?
http://forums.visokio.com/discussion/2766/outputs-text-charactersformat-in-emailss
Tue, 25 Nov 2014 04:03:12 -0500Mees2766@/discussions We sometimes use the email output block in DM. We have an issue with the text format. The email received contains symbols that do not exist in the dataset entering the email block.
Example: "€" comes out as "?"
Do you have any suggestion how we can adjust this?
Thanks ]]>Display: Hiding Data Titles in browser versions?
http://forums.visokio.com/discussion/2799/display-hiding-data-titles-in-browser-versionss
Mon, 22 Dec 2014 06:20:57 -0500aeastwood2799@/discussions When using 2.8, I can hide data titles using Toolbars -> Data titles -> Show/Hide (and they are hidden from my view), but they then still appear when deploying to browsers as HTML5. Is there anything that can be done about this?
Thanks Alex]]>Date/Time: How to display day of week?
http://forums.visokio.com/discussion/2796/datetime-how-to-display-day-of-weeks
Fri, 19 Dec 2014 10:38:57 -0500cristian2796@/discussionsI want to create a chart that has days 1-31 on the x-axis. Aggregation is on sales amount. I have a table with transactions for each day for a complete year and I want to show the sales per day regardless of month. Is there a date function that extracts the day of the date? I tried to use the Expand Values block but I can't choose my date field in "Field selection" of the block. Any suggestions?
Br Cristian]]>Exports: Need CSV with cell quotes but don't see cell quotes?
http://forums.visokio.com/discussion/2797/exports-need-csv-with-cell-quotes-but-dont-see-cell-quotess
Fri, 19 Dec 2014 12:51:07 -0500tjbate2797@/discussionsFiltering: Maintain filter selection across tabs?
http://forums.visokio.com/discussion/2792/filtering-maintain-filter-selection-across-tabss
Wed, 17 Dec 2014 09:07:47 -0500Bart2792@/discussionsBar/Line View: Strange axis scale problem?
http://forums.visokio.com/discussion/2782/barline-view-strange-axis-scale-problems
Thu, 11 Dec 2014 12:22:29 -0500aeastwood2782@/discussions Is there anything I can do about this?
Thanks]]>Export: Publish automatically only on given dates (e.g. month ends)?
http://forums.visokio.com/discussion/2781/export-publish-automatically-only-on-given-dates-e.g.-month-endss
Thu, 11 Dec 2014 10:57:29 -0500aeastwood2781@/discussions I'd like to be able to automatically publish an .IOK output at each month end (timestamped - but I already know how to do that). Is there a way to do this?
Thanks]]>Scheduler: Changing IOK File settings with Scheduler actions?
http://forums.visokio.com/discussion/2778/scheduler-changing-iok-file-settings-with-scheduler-actionss
Thu, 04 Dec 2014 06:17:18 -0500alexandervolk2778@/discussions Many thanks!]]>Outputs: Changing Interface Mode in Viewer or by Scheduler?
http://forums.visokio.com/discussion/2774/outputs-changing-interface-mode-in-viewer-or-by-schedulers
Fri, 28 Nov 2014 06:00:07 -0500alexandervolk2774@/discussions If not, is there a Scheduler action that can change the interface mode?
Essentially, we want a duplicate of an IOK to be saved as an HTML5 file, so the client can choose how to view their file.
Thanks!]]>Export: Enable Export View Data from browser-deployed HTML
http://forums.visokio.com/discussion/2735/export-enable-export-view-data-from-browser-deployed-html
Wed, 01 Oct 2014 06:19:15 -0400paola2735@/discussions This option can be enabled from Desktop Edition or from the Server interface.
Desktop steps: Settings>Web sharing>Edit client settings>Server settings Edit>Export view data
Server steps: From the Omniscope Web Server Services screen>Config>Permissions>Default Folder Config> Anonymous permissions>Export view data
This option will enable all recipients to export data from their browser. If you wish to customise this further and enable it only for certain groups of users, please create Groups settings (as per image).
]]>R Analytics: Encountering script error?
http://forums.visokio.com/discussion/2771/r-analytics-encountering-script-errors
Wed, 26 Nov 2014 19:20:20 -0500mbj9992771@/discussions The script runs in R but gives me the attached errors in Omniscope.
Any feedback/thoughts?
Martin Jetton
]]>Formulae: Identify date/time in the next 60 minutes
http://forums.visokio.com/discussion/2764/formulae-identify-datetime-in-the-next-60-minutes
Mon, 24 Nov 2014 04:15:48 -0500nash2764@/discussions Date Result 15.05.2014 15:05:55 no 15.05.2014 17:10:55 yes 15.05.2014 17:20:55 no
I tried a similar logic as for moving average, but it didn’t work. I am not sure why. Maybe the date/time format works differently. ]]>Styling: Setting Data Colours to match corporate standards
http://forums.visokio.com/discussion/2765/styling-setting-data-colours-to-match-corporate-standards
Mon, 24 Nov 2014 10:38:03 -0500StefanikovaI2765@/discussions I have a problem in Omniscope and question for you. I need to set our corporate color in Omniscope.
Can you help me with this? I need to have every color column in our color based on RGB. Not only one base colour.
Thank you very much for your advice.
]]>Filtering: Named Query diagnostic incorrect?
http://forums.visokio.com/discussion/2759/filtering-named-query-diagnostic-incorrects
Wed, 12 Nov 2014 08:53:05 -0500DominicChan2759@/discussionsSecurity: Owner locked IOK inside an ILF file: Copying allowed?
http://forums.visokio.com/discussion/2762/security-owner-locked-iok-inside-an-ilf-file-copying-alloweds
Thu, 20 Nov 2014 08:53:48 -0500Alexander2762@/discussions Inside an ILF file, we load an IOK file. The IOK file contains table views and pivot table views.
We can copy to Excel from the Pivot View, but from the Table View, this is not possible.
What are we doing wrong? Just a setting perhaps?
Thanks!]]>Labelling: Changing Smart Data Labelling?
http://forums.visokio.com/discussion/2760/labelling-changing-smart-data-labellings
Thu, 13 Nov 2014 12:06:49 -0500nash2760@/discussionsAnd for the week "w 9" to get "w 09"? Would be great. ]]>Formulae: Date/Time format for cumulative hours beyond 24?
http://forums.visokio.com/discussion/2758/formulae-datetime-format-for-cumulative-hours-beyond-24s
Mon, 10 Nov 2014 15:49:12 -0500aozols2758@/discussions The issue that I'm running into is when summing my "total session duration" date field. The HH:mm:ss format works up until the hour parameter hits 24 (as the setting for HH is a 24-hour clock). Is there a way to get around this 24-hour restriction? Should I be using a different format?
Example attached.
]]>Formulae: Weighted Average in Content View & stacked Bar Charts?
http://forums.visokio.com/discussion/2757/formulae-weighted-average-in-content-view-stacked-bar-chartss
Fri, 07 Nov 2014 05:06:09 -0500DominicChan2757@/discussions Also, when doing a weighted average in the Bar View, after stacking the bars, the figure displayed at the top of the bars are the sum of the stacking buckets. How can I make the figures on top of the bars to display an overall weighted average?
Thanks Dom]]>Export: Grouped Table View data to Excel?
http://forums.visokio.com/discussion/2752/export-grouped-table-view-data-to-excels
Sun, 02 Nov 2014 14:06:51 -0500kmatrix9992752@/discussions I have grouped and filtered data in table view. I have tried to export the data to Excel but lose the grouping.
Is there a way to export data to Excel and retained the grouping and sub totals?]]>