General http://forums.visokio.com/categories/general/p10/feed.rss Mon, 30 Oct 17 14:46:49 -0400 General en-CA Connector: Outlook PST files (2.7+) http://forums.visokio.com/discussion/886/connector-outlook-pst-files-2.7- Tue, 26 Jul 2011 03:35:17 -0400 steve 886@/discussions Formulae: Using Contains Function? http://forums.visokio.com/discussion/2143/formulae-using-contains-functions Wed, 15 May 2013 04:58:26 -0400 nicci113 2143@/discussions IF(SEARCH("pet",[Product],"PET Brand")

Sorry Guys, this contains function is really annoying and searching for alternatives, please suggest.

What I'm doing above is I'm searching Word "Brand" within campaign and "pet" within product and calliing it pet brand within another column,

Could anybody suggest how to make it work?]]>
New view: Radar View? http://forums.visokio.com/discussion/281/new-view-radar-views Tue, 06 Apr 2010 20:35:00 -0400 Pascal 281@/discussions Map View: Importing Overlays/Map Boundaries http://forums.visokio.com/discussion/583/map-view-importing-overlaysmap-boundaries Mon, 10 Jan 2011 09:18:34 -0500 Daniel_Lam 583@/discussions
The boundaries I am looking for are from the NUTS regional classifications in Europe such as the ones given here:

http://epp.eurostat.ec.europa.eu/portal/page/portal/gisco/geodata/reference by selecting the "Administrative units/Statistical units"

The idea is to be able to use these map boundaries in conjunction with heat mapping so that defined areas can be coloured for a set of numerical variables.

An Example I would like to be able to emulate:

http://static.guim.co.uk/sys-images/Guardian/Pix/pictures/2009/5/20/1242833437919/heat_map460.jpg]]>
Bar/Line View: Custom Y axis scaling http://forums.visokio.com/discussion/2115/barline-view-custom-y-axis-scaling Thu, 02 May 2013 09:21:31 -0400 bfromson1 2115@/discussions Filtering: Apply filter settings to selected tabs or an entire file? http://forums.visokio.com/discussion/2123/filtering-apply-filter-settings-to-selected-tabs-or-an-entire-files Fri, 03 May 2013 11:48:04 -0400 johnu 2123@/discussions
I have an iok file with about 20 tabs and each tab needs to be filtered by one of 30 people's names before saving to a pdf for that person. It would save so much time if I only had to filter 30 times rather than the 600 times now.

Thanks.]]>
Refresh: Refreshing files created in Desktop Edition? http://forums.visokio.com/discussion/1926/refresh-refreshing-files-created-in-desktop-editions Thu, 29 Nov 2012 05:39:23 -0500 ZhouNan 1926@/discussions From my understanding, even if the data source blocks in DataManager are scheduled to refresh every night, these updates will not refresh from the database if the file is open in the free Viewer.

If this is correct, is it any auto process I can implement rather than manually configure it everyday...Many thanks!
]]>
Integration: Scheduling jobs on different machines? http://forums.visokio.com/discussion/2097/integration-scheduling-jobs-on-different-machiness Thu, 18 Apr 2013 07:09:24 -0400 SteveP 2097@/discussions Mapping: Shortest Route distance calculation? http://forums.visokio.com/discussion/2108/mapping-shortest-route-distance-calculations Wed, 24 Apr 2013 15:37:08 -0400 Alexander 2108@/discussions
I would like to calculate the distance between 2 addresses based on the shortest route. The existing function 'Lat_Lon_Distance' returns the surface straight-line distance.

Has anyone done this before? Or do you have suggestions how I can do this?

Thanks in advance! Regards, Alexander ]]>
Outputs: Exporting to Excel xlsm/xlsx? http://forums.visokio.com/discussion/2098/outputs-exporting-to-excel-xlsmxlsxs Fri, 19 Apr 2013 01:16:33 -0400 Mai 2098@/discussions Thanks for your advice.
Regards, Mai]]>
Installation: Running both 2.7 & 2.8? http://forums.visokio.com/discussion/2102/installation-running-both-2.7-2.8s Mon, 22 Apr 2013 05:41:46 -0400 aknotts 2102@/discussions
Thanks

Andy]]>
Layout: Sub Tab Groupings? http://forums.visokio.com/discussion/1149/layout-sub-tab-groupingss Wed, 07 Dec 2011 05:11:56 -0500 TomW 1149@/discussions
By this I mean that when I click on the current tab structure, below that a further set of options are available, e.g. I have one tab that is Buzz and below that I am then given the options of Facebook, Twitter, General etc. When you click on any of these sub-tabs a new page appears with this information in rather than having to click on the device bar. These sub tabs would change depending on the top tab you select.

Is this possible or is there a way that something similar can be done with Macro type set up? i.e. can I put a line of queries along the top of the tab?

Thanks]]>
Layout: Sub-Tab Groupings? http://forums.visokio.com/discussion/2079/layout-sub-tab-groupingss Tue, 02 Apr 2013 08:23:10 -0400 rajeshbalu29 2079@/discussions
Equity_Global Colapse state and when expand all then it should show Equity_Global_Problems,Equity_Global_Changes,Equity_Global_Incidents,Equity_Global_Actions etc...

Please let me know in case if we have any option to get this feature.]]>
Performance: Refreshing heavy views from database? http://forums.visokio.com/discussion/2092/performance-refreshing-heavy-views-from-databases Tue, 16 Apr 2013 12:56:31 -0400 Alfonso 2092@/discussions
In the refreshing process, we have issues updating from the database. The issues happens in heavy queries or heavy views, resulting in a no coherent model at user interface level.

Could be the asking database time the cause. Is there experiences managing the updating interval for solving this kind of issues?.

Thanks in advance, Alfonso]]>
Layout: Floating Filter Devices (2.8+) http://forums.visokio.com/discussion/1008/layout-floating-filter-devices-2.8- Thu, 22 Sep 2011 11:26:35 -0400 alexhoward 1008@/discussions Formulae: Normal Distribution functions added http://forums.visokio.com/discussion/2091/formulae-normal-distribution-functions-added Mon, 15 Apr 2013 05:50:02 -0400 bfromson1 2091@/discussions
Thanks]]>
Mapping: Geocoding - Yahoo server no longer working? http://forums.visokio.com/discussion/2084/mapping-geocoding-yahoo-server-no-longer-workings Fri, 05 Apr 2013 11:08:16 -0400 andy_white 2084@/discussions Mapping: OpenStreetMap XML data import/export? http://forums.visokio.com/discussion/2094/mapping-openstreetmap-xml-data-importexports Tue, 16 Apr 2013 17:41:14 -0400 daniel 2094@/discussions
I've tried using the XML mapping input block and also to manually split up the data into Omniscope but I seem to be missing the objects and block types you would get if you put them into say CityEngine (see image). It is therefore difficult to group up all the various lines of data into the right subgroups.

Obviously this exercise is much more GIS orientated but in the example attached I am accessing the lat/long values so they can be mapped as points, I'm just having problems with the data structure in grouping and the tags.

Any help will be appreciated]]>
Links: Linking to another IOK file for Details? http://forums.visokio.com/discussion/2086/links-linking-to-another-iok-file-for-detailss Tue, 09 Apr 2013 05:28:55 -0400 aknotts 2086@/discussions
I have used parameter passing from one IOK to another and I don't want to do this. I am thinking more or a show details kind of thing.

Thanks, Andy]]>
Formulae: RUNNINGTOTAL sorting issue? http://forums.visokio.com/discussion/2082/formulae-runningtotal-sorting-issues Thu, 04 Apr 2013 09:07:03 -0400 cpvk 2082@/discussions
I have a question on the function RUNNINGTOTAL, and wondering if anyone could help.

I want to add Sales cash cumulatively by week for a particular SKU/Year combination.

I have the following formula in a field called "Cumulative Spend"

RUNNINGTOTAL([Sales Cash],SUBSET2([Sku],[Year]),false)

So this adds by year/SKU, but not in the right week order. I've tried to do a sort on the data-set to help. But was wondering if there was a smarter way. I have just downloaded the latest 2.8 version this morning.

Basically, it sort of works, but it doesn't add in Week order. Is there any way to make this happen?

Thanks]]>
Scheduler: multiple instances running many tasks? http://forums.visokio.com/discussion/2087/scheduler-multiple-instances-running-many-taskss Tue, 09 Apr 2013 06:04:13 -0400 Alexander 2087@/discussions
We are having trouble with a rather strange problem within our Schedulers. On our server we have 4 Scheduler instances running simultaneously. The last few weeks some tasks that are scheduled were not started, and in the log these tasks do not appear at all.

Last week we thought we discovered a pattern in this problem. As we schedule many tasks rapidly after each other, the queue builds up. I think that when Omniscope is using a lot of RAM, this queue is forgotten. Another plausible reason could be that “garbage collection” or “diagnostics ”actions also delete this queue.

The problem is that we cannot recreate the situation, but when it happens, this problem obviously disturbs our processes.

We solved the problem in one particular situation by leaving more time between the different tasks in order to avoid accumulating a queue of undone tasks.

Hope you guys can explain how the queue works and what reasons could be causing this problem? Thanks!
]]>
Refresh: Update all blocks vs Update from Source? http://forums.visokio.com/discussion/2077/refresh-update-all-blocks-vs-update-from-sources Tue, 02 Apr 2013 07:02:01 -0400 Alfonso 2077@/discussions
The experiment was, open the IOK without data and refill it using the standard method suggested in the documentation.

Preparation:

- Open a IOK file (wich is connected to a Mysql server Database) without data (tools/advanced/debugging/open without data). As result the model is empty (the model has up to 500.000 rows).
- Database updtate connection for each block (up to 10 different blocks) is configured as update when needed, It is checked and works well.

Test1: When the IOK without data opened I inserted CTRL F5 (update from source) and after a while it only bring up 12.000 rows.

Test2: Then I pushed the icon in the tool bar of datamanager tab, called 'update all', as after a huge time (up to 1/2 hour) the result was up to 500.000 rows.

I'm wondering what I do wrong, because the standard user workflow is CTRL F5 seems not guarantee the correct upto date of my model.

Please could you help me to understand the correct way to users can refresh data in autonome mode and what is the difference between two methods?.

Thanks in advance,

Alfonso
Attached configuration's details image]]>
Installation: Terminated Abnormally? http://forums.visokio.com/discussion/2043/installation-terminated-abnormallys Mon, 11 Mar 2013 11:45:03 -0400 sherriff 2043@/discussions "Visokio Omniscope terminated abnormally. If you are unable to start Visokio Omniscope, please use the diagnostics launcher ....send any output to Visokio".

I have run the debug.exe but cannot see how to send the output to Visokio.

I still cannot start Omniscope. Is there a fix? Should I uninstall and clear all the folders? If so which folders?]]>
Connectors: DoubleClick connection problems http://forums.visokio.com/discussion/2076/connectors-doubleclick-connection-problems Thu, 28 Mar 2013 07:46:21 -0400 chris 2076@/discussions Cycling Toolbar: Animation by time? http://forums.visokio.com/discussion/2072/cycling-toolbar-animation-by-times Tue, 26 Mar 2013 08:12:07 -0400 PaulChapman 2072@/discussions Can you point me in the right direction?

Thanks,]]>
DataManager: Splitting datasets into multiple files/tabs? http://forums.visokio.com/discussion/2065/datamanager-splitting-datasets-into-multiple-filestabss Wed, 20 Mar 2013 05:14:09 -0400 grahamb 2065@/discussions
For instance, say there as an analysis breaking down sales territories by sales and customers. The user would first define a map (or chart, table, etc.) showing all sales people territories, with customer markers etc. They would then activate split file to auto group by sales person. They would then have the option to either auto generate new tabs - each showing a specific sales territory map and customers and analysis relating to that territory - and/or generate multi-page output, without needing further selection.
]]>
Analytics: Recency Frequency Value? http://forums.visokio.com/discussion/2049/analytics-recency-frequency-values Fri, 15 Mar 2013 08:46:47 -0400 grahamb 2049@/discussions Bar/Line View: Funnel or Pyramid Chart? http://forums.visokio.com/discussion/2068/barline-view-funnel-or-pyramid-charts Thu, 21 Mar 2013 12:44:41 -0400 grahamb 2068@/discussions Connector: Twitter feed? http://forums.visokio.com/discussion/1438/connector-twitter-feeds Fri, 30 Mar 2012 04:44:30 -0400 OmarKhan 1438@/discussions The data that would be useful to have in it (but probably this will depend on what Twitter has to offer for their analytics?):

• Information on tweets (by day):
a. Clicks on tweet
b. Retweets of tweet
c. Replies on tweet
d. Total Reach (by tweet or by day)
e. …
• Information on followers:
a. Number of followers (by day)
b. Screen name / Name
c. Description
d. Location / Time zone
e. Key words on followers (but I don’t think this will be possible)
f. …
]]>
DataManager: Resetting display delete confirmation? http://forums.visokio.com/discussion/2058/datamanager-resetting-display-delete-confirmations Mon, 18 Mar 2013 09:08:55 -0400 SteveP 2058@/discussions Thanks, Steve]]>