Support http://forums.visokio.com/categories/support/p5/feed.rss Mon, 30 Oct 17 12:00:01 -0400 Support en-CA Outputs: 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 -0500 alex7thompson 2820@/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 -0500 carlosmartinmari 2823@/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 -0500 carlosmartinmari 2806@/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 -0500 nash 2821@/discussions At 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 -0500 aknotts 2817@/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 -0500 CRead 2789@/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 -0500 kmatrix999 2808@/discussions Google 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 -0500 DominicChan 2809@/discussions
We have been using the Google feed for some high-level MI on our web traffic via Google Analytics.

We have recently enabled UserID Web Tracking function in GA ( https://support.google.com/analytics/answer/3123666?hl=en-GB )

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 -0500 stavro 2801@/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 -0500 stavro 2785@/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 -0500 stavro 2784@/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 -0500 Mees 2766@/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 -0500 aeastwood 2799@/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 -0500 cristian 2796@/discussions I 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 -0500 tjbate 2797@/discussions Filtering: Maintain filter selection across tabs? http://forums.visokio.com/discussion/2792/filtering-maintain-filter-selection-across-tabss Wed, 17 Dec 2014 09:07:47 -0500 Bart 2792@/discussions Bar/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 -0500 aeastwood 2782@/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 -0500 aeastwood 2781@/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 -0500 alexandervolk 2778@/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 -0500 alexandervolk 2774@/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 -0400 paola 2735@/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).

image]]>
R Analytics: Encountering script error? http://forums.visokio.com/discussion/2771/r-analytics-encountering-script-errors Wed, 26 Nov 2014 19:20:20 -0500 mbj999 2771@/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 -0500 nash 2764@/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 -0500 StefanikovaI 2765@/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 -0500 DominicChan 2759@/discussions Security: 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 -0500 Alexander 2762@/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 -0500 nash 2760@/discussions And 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 -0500 aozols 2758@/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.

image]]>
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 -0500 DominicChan 2757@/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 -0500 kmatrix999 2752@/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?]]>