General http://forums.visokio.com/categories/general/p8/feed.rss Mon, 30 Oct 17 14:44:50 -0400 General en-CA Refresh: Batch Appends? http://forums.visokio.com/discussion/2391/refresh-batch-appendss Tue, 29 Oct 2013 10:24:08 -0400 kmatrix999 2391@/discussions Pivot View: Axes value ordering version 2.9? http://forums.visokio.com/discussion/2393/pivot-view-axes-value-ordering-version-2.9s Wed, 30 Oct 2013 07:08:20 -0400 davedunckley 2393@/discussions
Is it possible to drag the order of the valuses on the axis, like you can in excel?

Thanks

Dave
]]>
Connectors: Facebook connector problems http://forums.visokio.com/discussion/2387/connectors-facebook-connector-problems Mon, 28 Oct 2013 06:22:45 -0400 chris 2387@/discussions
There are currently problems with the Facebook connector. We are working to resolve these problems. I'll post an update once we have more information.

Chris]]>
Connectors: DoubleClick/DFA API in 2.8 versus 2.9? http://forums.visokio.com/discussion/2385/connectors-doubleclickdfa-api-in-2.8-versus-2.9s Wed, 23 Oct 2013 10:15:27 -0400 daniel 2385@/discussions
]]>
Performance: DataManager flow being slow/unresponsive? (2.8) http://forums.visokio.com/discussion/2384/performance-datamanager-flow-being-slowunresponsives-2.8 Wed, 23 Oct 2013 08:31:29 -0400 CRead 2384@/discussions
I'm not talking about the actual calculation of fields, or how long a file takes to refresh - but simple operations such as adding a field, expanding a block, bringing up the right click menu, selecting blocks.

It's not specific to one file, or one block type. It doesn't require a lot of blocks, although as block count goes up, responsiveness goes through the floor to an almost comic degree.

I'm not anywhere near RAM limits in most cases, the CPU is often nigh idle, and there's no disk thrashing.]]>
Refresh: Multi-file with central IOK 'datamart'? http://forums.visokio.com/discussion/2357/refresh-multi-file-with-central-iok-datamarts Mon, 30 Sep 2013 07:10:38 -0400 Alexander 2357@/discussions
Some of our dashboards are using a lot of data. We are looking into the possibilities of using 'datamart' iok files in order to decrease the dataload in the local Omniscope files. If I understand correctly, it works as follows:

1. IOK file that is the server-based datamart file, and has all the source data in it.
2. Dashboard IOK File, that has the datamart IOK file as its source.

Now I would like to load only the selected data from the 'datamart' file into the local 'dashboard' IOK. For example, I have visits of representatives of all 2013 in my server-based 'datamart' file, but I only want the last 2 weeks refreshed into the local 'dashboard' Omniscope report IOK.

The selection of the data would be done by the end-user and is exactly what I need. Where do I start? Is there an instruction or demo file that I can look into?

Thanks in advance!]]>
Forcing 32-bit launch from command line? http://forums.visokio.com/discussion/2378/forcing-32-bit-launch-from-command-lines Wed, 16 Oct 2013 04:47:30 -0400 Guy_Cuthbert 2378@/discussions Copy blocks from one datamanager to another datamanager file http://forums.visokio.com/discussion/2377/copy-blocks-from-one-datamanager-to-another-datamanager-file Tue, 15 Oct 2013 16:14:09 -0400 Alexander 2377@/discussions
In 2.7 we used to copy one datamanager workflow into another datamanager.
In 2.8 I can't figure it out how I could to something like that?

Hope you can help

Thanks,
Alexander]]>
Map View: Labelling lines between cities? http://forums.visokio.com/discussion/2370/map-view-labelling-lines-between-citiess Tue, 08 Oct 2013 12:36:27 -0400 iazcac 2370@/discussions
I am trying to visualise some data on flight routes. The columns I have are:

I have connected the lines between the cities using long and lat coordinates.

I now want to put a label on the line to show the number of flights, or maybe change colour of line based on how many flights.

Is this possible?

Thanks

]]>
Deployment: Download IOK web links not working in IE? http://forums.visokio.com/discussion/2355/deployment-download-iok-web-links-not-working-in-ies Mon, 30 Sep 2013 05:44:48 -0400 SteveP 2355@/discussions
The example page below contains two links to the same file - the first is pointing to one of Visokio's example files, on their website. The second link points to exactly the same file on our server.

www.talysis.co.uk/example.html

The second link is failing for me (let me know if it works in IE for you!), which suggests it is something on our server which is causing the problem. But what? ]]>
Gartner BI and Analytics Report http://forums.visokio.com/discussion/2361/gartner-bi-and-analytics-report Wed, 02 Oct 2013 06:38:23 -0400 acohen 2361@/discussions
http://www.gartner.com/technology/reprints.do?id=1-1DZLPEK&ct=130207&st=sb]]>
Sidebar: Hide Filter row counts? http://forums.visokio.com/discussion/2359/sidebar-hide-filter-row-countss Mon, 30 Sep 2013 11:15:43 -0400 davedunckley 2359@/discussions
Next to each item in the device menu, is a total. This is a total of records that could be selected by that option, however we would like to hide this, as it does not mean a lot. Is there a way to do this?]]>
Aggregation: Delete all fields option? http://forums.visokio.com/discussion/2304/aggregation-delete-all-fields-options Wed, 04 Sep 2013 06:17:54 -0400 Alexander 2304@/discussions
The option to delete all fields in the aggregation block in version 2.7 was very handy. In large datasets, it is easier to delete all, and then reset the fields needed. Now I should set the fields that I do not need anymore in the downstream dataflow to "none" in the pulldown menu? Or I can create a workaround by using a field organiser or validate data block 'above' the aggregation block?

Hope this functionality can be re-integrated in 2.8. Thanks. ]]>
Connectors: Brandwatch problems http://forums.visokio.com/discussion/2302/connectors-brandwatch-problems Thu, 29 Aug 2013 12:32:05 -0400 chris 2302@/discussions
Apologies for any inconvenience this has caused.

Brandwatch are looking to release a new API shortly, so we may hold off any major changes until then. Once the new API has been released we will update the connector. Please let us know if you have any additional requirements/ideas for the Brandwatch connector. For example, are there any additional reports you'd like to see? We will try to integrate as many ideas as possible.]]>
Version 2.8 - Hide all unused devices not working? http://forums.visokio.com/discussion/2307/version-2.8-hide-all-unused-devices-not-workings Thu, 05 Sep 2013 12:03:58 -0400 Steve_Randall 2307@/discussions Thanks
Steve]]>
Validate block needs activation in 2.8 http://forums.visokio.com/discussion/2309/validate-block-needs-activation-in-2.8 Fri, 06 Sep 2013 07:10:37 -0400 Alexander 2309@/discussions
The validate blocks in datamanager files that we saved in 2.7 are not executed automatically in 2.8.
Scheduled chain actions are executed without loading the validate blocks.
This is a cause of a lot of work for us. We need to open the datamanager file and execute the validate block.

Hope you can help.
Thanks]]>
Filtering: Recordfilter > in version 2.7 is >= in 2.8 http://forums.visokio.com/discussion/2310/filtering-recordfilter-in-version-2.7-is-in-2.8 Fri, 06 Sep 2013 07:16:08 -0400 Alexander 2310@/discussions
We have another problem in 2.8. We have record filter that is set with the ">" argument in 2.7. When opening the same DataManager Record Filter block in 2.8 the argument is changed to ">=". This is causing problems.

Hope you can help on short notice.

Thanks]]>
Geocoding - Adding Mapquest, Cloudmade and Gisgraphy server connectors? http://forums.visokio.com/discussion/2306/geocoding-adding-mapquest-cloudmade-and-gisgraphy-server-connectorss Wed, 04 Sep 2013 10:30:29 -0400 daniel 2306@/discussions
http://www.mapquestapi.com/geocoding/#optionssample - limited to 100 per call

http://cloudmade.com/ - Apparently upto 100k calls per month

http://www.gisgraphy.com/


I think they all require sign ups and API keys to be created dynamically?]]>
Aggregation: Function "Non-empty count"? http://forums.visokio.com/discussion/2295/aggregation-function-non-empty-counts Fri, 23 Aug 2013 05:36:37 -0400 Mees 2295@/discussions Is this expected behavior? Will be useful when this is possible.

Thanks, A]]>
Variables: How to calculate proportions with dynamic formulas? http://forums.visokio.com/discussion/2299/variables-how-to-calculate-proportions-with-dynamic-formulass Thu, 29 Aug 2013 04:50:45 -0400 Insightgroup 2299@/discussions
At the moment Omniscope only gives us the frequencies of 1's - i.e. we can’t get it to calculate the proportions automatically.

Does anyone have any suggestions?

Thank you in advance.
]]>
Formulae: MAX ABS UNIQUE VALUE? http://forums.visokio.com/discussion/2298/formulae-max-abs-unique-values Wed, 28 Aug 2013 12:01:05 -0400 lowellchung 2298@/discussions
If there is more than one instance of the max number, I just want to be able to take/flag one of then not both.

Cheers, Lowell]]>
Formulae: Two conditions in an IF statement using AND? http://forums.visokio.com/discussion/2293/formulae-two-conditions-in-an-if-statement-using-ands Mon, 19 Aug 2013 16:21:41 -0400 amitbdesai 2293@/discussions I want to put two condtions on these values like [TotalCommission]>0 and [TotalSales]>0 in IF statement.
How can I do this question becausI am placing "AND" between this two statement but this does not work.

My current formula looks like:

IF(([GrossTotalCommission]>0 AND [GrossTotalSales]>0),([GrossTotalCommission]/[GrossTotalSales]),(SUM([CJTotalCommission]+[PPJTotalCommission]+[IRTotalFee]+[AdditionalFeeVertive]+[AdditionalFeeDarren])/([CJOrders]+[IROrders]+[PPJOrders]))

EWhat can I add or improve to this statement to get result?

Any help appreciate. Thanks a lot in advance.
Amit]]>
Map View: Boundary overlay layer for ITV Regions? http://forums.visokio.com/discussion/787/map-view-boundary-overlay-layer-for-itv-regionss Sun, 22 May 2011 10:03:09 -0400 checkyourfuel 787@/discussions http://bit.ly/mhi3GB).

On a related note, I was recently told that Google has its own of view on UK TV consumption and so has, allegedly, created its own designated market area (DMA) i.e. Google Marketing Area (GMA). If true, this might be a useful addition in Omniscope as well.]]>
Date/Time: Crossing time zones in version 2.7? http://forums.visokio.com/discussion/1614/datetime-crossing-time-zones-in-version-2.7s Wed, 20 Jun 2012 01:38:51 -0400 rajeshbalu29 1614@/discussions There is a issue in a bar chart axis as attached 2 snapshots one from a licensed version which displays the months properly but if I send the same IOK file to the user who is having a free Viewer access with build 296, the month in axis starts with one month before. Please find the below attached snapshot and let me know icase of any updates on the same.

Regards, Rajesh B]]>
Pivot View: Export pivoted data now enabled http://forums.visokio.com/discussion/2174/pivot-view-export-pivoted-data-now-enabled Thu, 30 May 2013 04:05:43 -0400 alexPIB 2174@/discussions Are there any plans to make exporting data as a pivot easier?

I seem to remember an 'export as pivot' option on a 2.7 build a while ago but now it no longer exists?]]>
Formulae: Conditional values? http://forums.visokio.com/discussion/2278/formulae-conditional-valuess- Fri, 09 Aug 2013 12:30:30 -0400 amitbdesai 2278@/discussions
Now the condition is like:
If Sales > 0 then I want to could leads based on sales value.
The resulting values will be inserted in [Leads] column.
Basically, how to put condition to get desired value or column?

I hope this information is enough for you and if you need more specific or something else just let me know so i can provide to ASAP. Thanks in advance for your help.]]>
Aggregation: all dates into one date? http://forums.visokio.com/discussion/2277/aggregation-all-dates-into-one-dates Thu, 08 Aug 2013 13:02:20 -0400 amitbdesai 2277@/discussions For e.g: there are 10 times this date 8/1/2013 with different value in revenue.
But i want to aggregate all this into one with aggregation of sum of revenue and only one time date i.e 8/1/2013.
How can i do this?]]>
Versions: Upgrading to version 2.8 ?? http://forums.visokio.com/discussion/2269/versions-upgrading-to-version-2.8-ss Tue, 30 Jul 2013 10:51:16 -0400 enrico68 2269@/discussions After having seen the last release notes, we would like to consider the idea to upgrade to version 2.8 (unfortunately this version is still a beta version).

In particular we are interested in the improvements of version 2.8 on
- aggregation function,
- pivot view
- the new radar view.

So, I'd like to ask if it can be safe to pass to version 2.8, considering that is only a beta release.

Is there any idea about when version 2.8 will became a stable release?

Thanks
]]>
Mapping: Coordinate conversion-Lat/Long to British National Grid (2.7+) http://forums.visokio.com/discussion/1102/mapping-coordinate-conversion-latlong-to-british-national-grid-2.7- Fri, 18 Nov 2011 10:20:16 -0500 chris 1102@/discussions
In tonights 2.7 release you will see we have added two new functions:

CONVERT_LATLONG_TO_OSGBX and CONVERT_LATLONG_TO_OSGBY

These allow you to convert a coordinate from GPS lat/long to British national grid. The provide the opposite behaviour to the existing functions:

CONVERT_OSGB_TO_LAT and CONVERT_OSGB_TO_LON]]>
Batch Output-Email Output Type with PDF attachment http://forums.visokio.com/discussion/2260/batch-output-email-output-type-with-pdf-attachment Mon, 22 Jul 2013 08:22:23 -0400 OO83 2260@/discussions
I am trying to use the batch output block to send some files out and have chose my output type as 'Email'. I want a pdf to be attached in the email but this doesn't seem to work (it does work for an 'iok' or 'xlsx' extension).

Is there a reason for this or can it be made to work?

Thanks,

Ola.]]>