General http://forums.visokio.com/categories/general/p14/feed.rss Mon, 30 Oct 17 18:01:59 -0400 General en-CA Macs: Opening more than one Omniscope file at a time? http://forums.visokio.com/discussion/1808/macs-opening-more-than-one-omniscope-file-at-a-times Wed, 03 Oct 2012 11:06:45 -0400 alicew 1808@/discussions
Thanks, Alice

]]>
Outputs: formulas within re-published output IOK files? http://forums.visokio.com/discussion/1806/outputs-formulas-within-re-published-output-iok-filess Tue, 02 Oct 2012 08:29:39 -0400 ken 1806@/discussions
I then have a Bar/Line View in which I display this field. I aggregate by another field. In the aggregation I select to recalc the value of my new field using the formula - i.e. calculate the ratio of used amount/total amount for the aggregated values, and then display this in the view.

All works fine until I re-publish the Omniscope file below the blue box using a file Output block set to publish an IOK file. In the new, re-published IOK file, the display doesn't work? Surely formulas must survive the re-publishing process?]]>
Free Viewer: Export to Excel from free Viewer? http://forums.visokio.com/discussion/1797/free-viewer-export-to-excel-from-free-viewers Fri, 28 Sep 2012 07:28:45 -0400 p_parry 1797@/discussions
I CAN export this by using my Desktop Edition by selecting File->Export->Create Excel Spreadsheet and then chosing the option to export selected data. Please can I ask if firstly if I am missing something and this functionality is available in the free Viewer but I'm unable to find it? and secondly if I'm not missing anything, would it not be far more useful to have this function in the free Viewer from a data visibility point of view? N.B. I am currently operating on version 2.7 b734]]>
Bar/Line View: Labelling zero values? http://forums.visokio.com/discussion/1792/barline-view-labelling-zero-valuess Thu, 27 Sep 2012 08:05:53 -0400 dszl136154 1792@/discussions image]]> Filtering: (no value) - freeze? http://forums.visokio.com/discussion/1789/filtering-no-value-freezes Thu, 27 Sep 2012 06:45:40 -0400 dszl136154 1789@/discussions Bar/Line View: Mixing positive/negative values in stacked bars? http://forums.visokio.com/discussion/1759/barline-view-mixing-positivenegative-values-in-stacked-barss Tue, 11 Sep 2012 07:18:18 -0400 dszl136154 1759@/discussions image]]> Refresh: Updating Webstart distributed data files? http://forums.visokio.com/discussion/1766/refresh-updating-webstart-distributed-data-filess Tue, 18 Sep 2012 08:54:33 -0400 shaji_o 1766@/discussions Bar/Line View: Hiding labels? http://forums.visokio.com/discussion/1778/barline-view-hiding-labelss Fri, 21 Sep 2012 07:10:50 -0400 dszl136154 1778@/discussions Formulae: Time period comparisons - WoW or MoM? http://forums.visokio.com/discussion/1772/formulae-time-period-comparisons-wow-or-moms Wed, 19 Sep 2012 12:49:17 -0400 kgurus 1772@/discussions
I have two requirements and both are pretty much linked or part of the same solution:

1. I need to show a table view of metrics and their respective values corresponding to current and previous week. Also, I want to calculate the % different (WoW, MoM etc..) based on the user selections. How do I calculate previous week and show it in the data field?

2. If the user selects only quarter and does not select month or week then the current week and month should be taken as maximum of week and month in that particular quarter. Also, based on this, previous week should be calculated in the background and result should appear.

I have attached a file to explain the desired result. Any help would be greatly appreciated!

Thank you!]]>
Pie View: How to COUNT records instead of SUM? http://forums.visokio.com/discussion/1780/pie-view-how-to-count-records-instead-of-sums Fri, 21 Sep 2012 11:38:53 -0400 ZhouNan 1780@/discussions
I am new to Omniscope and trying to create a simple demo for a transaction table.

In the Pie View, I can select desired columns as Split and Measurement. But, when I select Amount as measurement column, the system automatically defaults the aggregation to SUM, and there is no place to change it.

Basically, what I am trying to achieve is to COUNT the number of Payments(Amount) column in the split instead of SUM all the amount values together in the split.

I also noticed that COUNT can be added in the Statistics box, but it is not what required.

Could anyone help me on this? Thank you very much! - Nan]]>
Sources: Missing worksheets interrupting flow downstream? http://forums.visokio.com/discussion/1774/sources-missing-worksheets-interrupting-flow-downstreams Thu, 20 Sep 2012 09:57:50 -0400 benjamin 1774@/discussions
My problem is that I have multiple files and some times these files are empty and the IT people instead of sending me empty files just do not send the files at all (I know i can just create a manual empty file with the same name , but i want the process to be fully automated)- Thanks Ben
]]>
Formulae: Conditional Links? http://forums.visokio.com/discussion/1450/formulae-conditional-linkss Wed, 04 Apr 2012 09:23:03 -0400 Kefsid 1450@/discussions Connector: Brandwatch http://forums.visokio.com/discussion/1775/connector-brandwatch Thu, 20 Sep 2012 12:46:00 -0400 chris 1775@/discussions Server: Auto-refreshing data in free Viewer? http://forums.visokio.com/discussion/1768/server-auto-refreshing-data-in-free-viewers Tue, 18 Sep 2012 09:56:37 -0400 DominicChan 1768@/discussions
The data source is entirely loaded from SQL servers, I have selected from the "Database Table" blocks the 'Update Option' of "Scheduled. Update every: 10 minutes" (note: all these blocks are connected to the servers with username and password, not user authentication). And have selected "Enable auto_refresh" + "Retrieve new data, notify and apply immediately" from the main menu the Data>Automatic Refresh.

If I use our ServerPlus licensed server to save and distribute these files, will my end users be able to leave the report open on their computers using free Viewer, and the report will refresh itself from the database every 10 minutes?

What are the restrictions if any? Thanks a lot.... Dom ]]>
Free Viewer: changing between bar and line in bar/line view? http://forums.visokio.com/discussion/1761/free-viewer-changing-between-bar-and-line-in-barline-views Wed, 12 Sep 2012 10:16:54 -0400 andy_white 1761@/discussions
Thanks, Andy]]>
DataManager: Copying/duplicating multiple blocks? http://forums.visokio.com/discussion/1763/datamanager-copyingduplicating-multiple-blockss Fri, 14 Sep 2012 07:23:43 -0400 dszl136154 1763@/discussions
Thanks]]>
Scheduler: Not running-Header Application Error? http://forums.visokio.com/discussion/1756/scheduler-not-running-header-application-errors Tue, 11 Sep 2012 04:27:54 -0400 davedunckley 1756@/discussions
I have schedules that run fine when set up and tested. But when left to run at the time specified, then fail with:-

Header Application Error

Any ideas?]]>
Venn View: Colouring options? http://forums.visokio.com/discussion/1758/venn-view-colouring-optionss Tue, 11 Sep 2012 06:51:21 -0400 dszl136154 1758@/discussions SUBSET Formulae: Average of data subsets? http://forums.visokio.com/discussion/1760/subset-formulae-average-of-data-subsetss Tue, 11 Sep 2012 09:32:26 -0400 Attiyyah 1760@/discussions Security: File security options? http://forums.visokio.com/discussion/1754/security-file-security-optionss Mon, 10 Sep 2012 07:59:48 -0400 revlin 1754@/discussions
Anyone have any experience of this?

Also, does this relate to a standalone Omniscope file or a Server-based approach. I understand that a Server-based solution is possible with Omniscope although I have only ever used the Desktop Edition of Omniscope. Any feedback would be greatly appreciated.
]]>
Formulae: Exporting formulae for documentation/audit (2.8+) http://forums.visokio.com/discussion/1695/formulae-exporting-formulae-for-documentationaudit-2.8- Fri, 10 Aug 2012 05:02:22 -0400 davedunckley 1695@/discussions Architecture: Editing data in HTML? http://forums.visokio.com/discussion/1745/architecture-editing-data-in-htmls Tue, 04 Sep 2012 13:42:12 -0400 DJRH 1745@/discussions Data Flows: 2 Validate blocks? http://forums.visokio.com/discussion/1744/data-flows-2-validate-blockss Tue, 04 Sep 2012 12:08:35 -0400 andy_white 1744@/discussions
The problem is, when we run this through the Scheduler, the action fails because one of the output streams cannot complete. Can you think of any way to resolve this - the problem we're trying to solve is identifying a problem with the data, therefore not publishing the new (incorrect) data into Omniscope but sending out an email to specific recepients to say it has failed and what the problem is?
]]>
Scheduler: XML Actions file options? http://forums.visokio.com/discussion/1733/scheduler-xml-actions-file-optionss Tue, 28 Aug 2012 05:27:23 -0400 andy_white 1733@/discussions
Is it possible to create an XML Actions task script that will create multiple files (so for example, open a source file, refresh it, save it with a new location as an IOM, then save it with a different new location as a domain locked IOK)?

Secondly, is it possible to have the option to pass a specific empty IOK template file/location within an XML Action script, so (with the above example) open a source file, refresh it, save it with a new location as an IOM, using an empty template file developed from a different source?

Andy]]>
Pivot View - (no value) http://forums.visokio.com/discussion/1719/pivot-view-no-value Tue, 21 Aug 2012 07:35:44 -0400 dszl136154 1719@/discussions
See attachedimage]]>
Modifying Field Data using Scripts http://forums.visokio.com/discussion/1741/modifying-field-data-using-scripts Fri, 31 Aug 2012 07:14:26 -0400 sjhstott 1741@/discussions
script(`
var array1 = subset_uniquesList("Operator");
var array2 = subset_uniqueslist("Con_L2Callstackdesc");
for (var i in array2) {
for (var j in array1) {
var str=array2[i];
var n=str.search(array1[j]);
if (n != -1) {
subset("Con_L2Callstackdesc",array2[i]) += "DINGDING"
}
}
}
`,[Con_L2Callstackdesc],[Operator])]]>
Web Start: Omniscope Online now displays Web View http://forums.visokio.com/discussion/540/web-start-omniscope-online-now-displays-web-view Thu, 02 Dec 2010 20:54:46 -0500 walsh 540@/discussions Scaling & Performance: Database tables/OLAP cubes? http://forums.visokio.com/discussion/1738/scaling-performance-database-tablesolap-cubess Thu, 30 Aug 2012 04:48:28 -0400 mburgess 1738@/discussions
If I used either database table or OLAP cube to read data into Omniscope how would this cope with 100 million or so records with a similar amount of fields?

I am also aware 2.8 version is meant to be focussing on performance - have there been any significant developments in data load or are you looking more at processes cross records (aggregation, sort, subset functions etc) for optimisation. Thanks Matt]]>
Connectors: Google Analytics http://forums.visokio.com/discussion/1730/connectors-google-analytics Fri, 24 Aug 2012 09:23:10 -0400 chris 1730@/discussions
We apologise for the inconvenience. ]]>
Formulae: Time differences? http://forums.visokio.com/discussion/1729/formulae-time-differencess Thu, 23 Aug 2012 12:43:15 -0400 dszl136154 1729@/discussions