General http://forums.visokio.com/categories/general/p9/feed.rss Mon, 30 Oct 17 14:44:55 -0400 General en-CA Bar/Line View: 2.7 migration to 2.8 data titles issue? http://forums.visokio.com/discussion/2237/barline-view-2.7-migration-to-2.8-data-titles-issues Tue, 09 Jul 2013 16:15:17 -0400 bgrovens 2237@/discussions
We are in the process of upgrading our server from 2.7 to 2.8. One thing we noticed is that with all reports previously produced in 2.7 we have "Layered by Measures" hidden to "Never" show. Example 1 below.
image

After you open the same report in 2.8 it unhides this and you can see "Layered By Measures" on every chart in every report. Can you please look into this, I can't modify our 100 producton reports by clicking on "Never" show on each chart of all reports to migrate. Please advise why this is turning on and how I can resolve this problem.
image

Thanks!]]>
Scheduler: Running from Linux Command-line? http://forums.visokio.com/discussion/2235/scheduler-running-from-linux-command-lines Tue, 09 Jul 2013 07:19:11 -0400 tamax 2235@/discussions
I would like to know if it is possible to install Visokio Scheduler on a Linux Server (without graphical interface) in order to have more CPU power for iok publishing.

Let me explain our situation:

- We have Omniscope Server Plus installed on a Windows server, with only 7.5GB of RAM.
- For some (very) big iok files the publishing task fails because of RAM limitation
- My idea is to use a bigger Linux server that would be in charge of iok publishing, but ideally the Scheduler would remain on the windows server, for ease of use.

Is it possible to do something like this? I am asking because Linux servers are much cheaper than windows, but I don't want to migrate the whole installation on Linux, just to use its CPU power.

Thanks, Maxime]]>
Connectors: DoubleClick-Text to date conversion with time zones? http://forums.visokio.com/discussion/2021/connectors-doubleclick-text-to-date-conversion-with-time-zoness Mon, 18 Feb 2013 10:49:13 -0500 ALC 2021@/discussions
Thanks, Anna
]]>
DataManager: 'Explore to' back in Data file output block? http://forums.visokio.com/discussion/2207/datamanager-explore-to-back-in-data-file-output-blocks Fri, 21 Jun 2013 09:42:36 -0400 alec_webliquid 2207@/discussions
Can we have this functionality back please? I used to use it all the time - I am sure I cannot be the only one missing it.

Cheers!]]>
Installation: Abnormal start messages? http://forums.visokio.com/discussion/2229/installation-abnormal-start-messagess Fri, 05 Jul 2013 04:40:25 -0400 Insightgroup 2229@/discussions image]]> Outputs: Exporting PDF from DataManager Block, formulae results? http://forums.visokio.com/discussion/2215/outputs-exporting-pdf-from-datamanager-block-formulae-resultss Thu, 27 Jun 2013 04:21:21 -0400 benjamin 2215@/discussions
In Omniscope, on the tabs the graphs are correct. Also, if from Omniscope Command menu I go File > Export to PDF, the exported PDF is the same as the Omniscope tabs (which is correct).

However, if I go to DataManager and add an Output to PDF block to the data flow after the blue "Omniscope" block, the PDF result is incorrect and it appears like the results are being summed rather than using the "Formulae" result.

Version 2.8 build 978 ....Please could you advise

Thanks, Ben
]]>
Graph View: Scatter Plot to display only top 10 values? http://forums.visokio.com/discussion/2212/graph-view-scatter-plot-to-display-only-top-10-valuess Tue, 25 Jun 2013 09:49:02 -0400 OmarKhan 2212@/discussions
Y axis is YoY change
X axis is SOV%

Size of bubble is the expenditure aggregated on a yearly basis

What would be perfect would be to have only the top ten brands shown depending on the filters on the side:

Category
Market
Gender
Focus Competitors


But it is empty when you try the filters.]]>
Email Output - Timestamp Field http://forums.visokio.com/discussion/2213/email-output-timestamp-field- Tue, 25 Jun 2013 10:24:28 -0400 cgamolo 2213@/discussions When setting up an email output, there is a checkbox under the Connection/Message tab to "Add subject timestamp", however, the "Timestamp format" field does not appear. You have to go to the Data tab and click on Advanced Options to make this field visible. Just something to keep in mind if you are looking for this field. This is for 2.8 build 993. ]]> Map View: Trans-pacific connections? http://forums.visokio.com/discussion/2210/map-view-trans-pacific-connectionss Sun, 23 Jun 2013 19:55:55 -0400 DBuzacott 2210@/discussions
I'm using map view to visualise some airline itineraries. For example, a flight itinerary of MEL-DXB-LHR will draw a line from Melbourne to Dubai to London. Attached is a (very small) subset of the data so that you can see what I'm talking about.

This works great, but we're having an issue with trans-pacific flights - e.g. Auckland-Santiago, Sydney-Los Angeles etc. Because of the way that the map view is structured, the connecting lines do not cross the pacific but instead go the long way around over Asia/Africa/Europe. This is very poor visually as it further clutters those areas of the map, and is also somewhat of a misrepresentation of the routes themselves. I've also tried this with a few different maps (both 'online' and 'offline' worlds) but no luck.

So my question is this: is there a way to 'wrap' the map view so that you can run connectors across the Pacific?

Thanks, Daniel]]>
Sources: connecting to SQL Server 2008 on local machine? http://forums.visokio.com/discussion/2196/sources-connecting-to-sql-server-2008-on-local-machines Tue, 18 Jun 2013 15:56:38 -0400 sfourwinds 2196@/discussions
Database error
An error occurred connecting to or querying the database.
Unknown server host name 'SIERRADEV\SQLEXPRESS'.

Detailed information
Unknown host: The server you are accessing does not exist or is not currently accessible.
SIERRADEV\SQLEXPRESS]]>
Formulae: Using SUBSET RECORDCOUNT? http://forums.visokio.com/discussion/2200/formulae-using-subset-recordcounts Wed, 19 Jun 2013 12:18:19 -0400 iazcac 2200@/discussions I have a data set in Omniscope including the fields

[Category] | [Country] | [EmployeeID]

In English, I want to count the number employees for each country where category = X. I have tried if, subsets and recordcount and just cant get it to work! Is probably simple, but any help appreciated

C]]>
Outputs: Auto-publishing to Excel? http://forums.visokio.com/discussion/2199/outputs-auto-publishing-to-excels Wed, 19 Jun 2013 11:24:17 -0400 AzulMorganti 2199@/discussions Thank you!]]> Outputs: "Disable background" as an Export to PDF option (2.8+) http://forums.visokio.com/discussion/1541/outputs-disable-background-as-an-export-to-pdf-option-2.8- Wed, 09 May 2012 11:54:48 -0400 OmarKhan 1541@/discussions Date/Time: Display/filter on symbols for Quarters? http://forums.visokio.com/discussion/1747/datetime-displayfilter-on-symbols-for-quarterss Wed, 05 Sep 2012 21:08:52 -0400 hgross 1747@/discussions http://www.visokio.com/dates-and-times]]> Pivot View: Copy Result as Pivot Table into Excel? http://forums.visokio.com/discussion/2026/pivot-view-copy-result-as-pivot-table-into-excels Thu, 21 Feb 2013 10:09:31 -0500 bfromson1 2026@/discussions
The "export view data" option exports all the underlying data - in a Table View the export view data actually exports the table as viewed?]]>
Sources: Flicker API - Reading multiple xml objects http://forums.visokio.com/discussion/2190/sources-flicker-api-reading-multiple-xml-objects Tue, 11 Jun 2013 11:02:03 -0400 daniel 2190@/discussions
Is there a way to expand out the attached xml information if the API request is not an original connection? I have created multiple dynamic links which is derived from one API request which fetches a set of images id and then creates 10+ new API requests specifically querying information for each ID. I am able to retrieve the xml output for each link but now have to process out these xml objects' information. Is it possible to expand these out using scripts or to create an expand xml operation block to do it within Omniscope?

I've also encountered similar issues with JSON data formats and haven't really figured out the best way to deal with these types of data. The discussion on scripting and php deserialization is along the same lines but the example Omniscope file doesn't seem to be working:

http://forums.visokio.com/discussion/comment/7953/#Comment_7953

The two Flicker API methods I am using here are:

To fetch new images by a radius location:
http://www.flickr.com/services/api/flickr.photos.search.html

To fetch the photo information:
http://www.flickr.com/services/api/flickr.photos.getInfo.html]]>
Output: Add time stamp with today's date to file names? http://forums.visokio.com/discussion/2192/output-add-time-stamp-with-todays-date-to-file-namess Thu, 13 Jun 2013 08:55:37 -0400 davedunckley 2192@/discussions
Is there the ability to automatically save an imported data snapshot or timeslice files with today's date as a suffix?

So I could in the Scheduler, have it save each snapshot/timestamp as 'filename_ and it would save the output as 'Filename_130613.iok'?

Dave
]]>
Layout: Lost DataManager Tab? http://forums.visokio.com/discussion/2189/layout-lost-datamanager-tabs Tue, 11 Jun 2013 09:46:12 -0400 Phillipa 2189@/discussions
I have checked the visible tab settings and manage tabs, but cannot find it. Is there any way of restoring it?

Phillipa]]>
Layout: Sub-tabs and moving tabs (2.8+)? http://forums.visokio.com/discussion/2185/layout-sub-tabs-and-moving-tabs-2.8-s Thu, 06 Jun 2013 04:28:17 -0400 Phillipa 2185@/discussions
How do I move Tabs? Before you could drop and drag them easily, this no longer works and I've just created a error reprot trying to do this in the manage tabs menu.

Thanks, Phillipa]]>
Performance: Managing disk cache size & location? http://forums.visokio.com/discussion/1290/performance-managing-disk-cache-size-locations Fri, 10 Feb 2012 04:54:25 -0500 mburgess 1290@/discussions
i have had the message that action cannot be completed because not enough disk space from Scheduler

Will this be because 5GB is not enough or 55GB is not enough (memory in use by javaw.exe was just over 50GB just before i got the message).

My question is essentially can we increase the D drive or add more hard drive space internally for visokio to use or does it need to be on the C drive?

Thanks, Matt]]>
Sources: Renaming folders of files? http://forums.visokio.com/discussion/2181/sources-renaming-folders-of-filess Wed, 05 Jun 2013 08:07:21 -0400 SteveP 2181@/discussions
If we try to open one of these files in a DataManager, there doesn't appear to be a way of doing it, without renaming the file to something like smith001.txt

Is there a way to EITHER open the files with their current names, OR do something to rename all of the files first?

Thanks]]>
Pie View: Othering in Pie Views? http://forums.visokio.com/discussion/1011/pie-view-othering-in-pie-viewss Tue, 27 Sep 2011 06:47:55 -0400 OmarKhan 1011@/discussions Map view: directed flows origin and destination? http://forums.visokio.com/discussion/2152/map-view-directed-flows-origin-and-destinations Sun, 19 May 2013 21:48:04 -0400 Pascal 2152@/discussions
PS: I added a screenshot of what I would expect it looks like.]]>
Formulae: SUBSET(MAX) Extract data with latest date? http://forums.visokio.com/discussion/2168/formulae-subsetmax-extract-data-with-latest-dates Sun, 26 May 2013 21:57:44 -0400 Nemesis 2168@/discussions
[A]| [B] | [C]

a | 1 | 10/12/2012
a | 2 | 10/13/2012
c | 1 | 10/14/2012
d | 2 | 10/15/2012
s | 3 | 10/16/2012
d | 3 | 10/17/2012
f | 212| 10/18/2012
g | 4 | 10/19/2012
e | 2 | 10/20/2012
a | 1 | 10/21/2012
e | 32 | 10/22/2012
a | 32 | 10/23/2012
b | 32 | 10/24/2012
a | 3 | 10/25/2012
b | 23 | 10/26/2012
c | 2 | 10/27/2012
c | 32 | 10/28/2012

Like "a" having latest data of:

"a 3 10/25/2012"

and similarly for all other unique values from column [A]. Any suggestions please!!]]>
Formulae: SUBSET - testing the same field for different values? http://forums.visokio.com/discussion/2160/formulae-subset-testing-the-same-field-for-different-valuess Wed, 22 May 2013 09:49:48 -0400 nicci113 2160@/discussions
If I want to select [NewField2] and look for values 'CARBRAND' then pick corresponding value from [Spend] and ADD that to where [Newfield2] value is 'PUREBRAND' and the value from [Media..] Highlighted in attachment]]>
De-Pivot Operation: converting rows to column for analysis? http://forums.visokio.com/discussion/2158/de-pivot-operation-converting-rows-to-column-for-analysiss Wed, 22 May 2013 04:57:56 -0400 nicci113 2158@/discussions Merge/Join: Many to One and rows matched don't tally? http://forums.visokio.com/discussion/2153/mergejoin-many-to-one-and-rows-matched-dont-tallys Mon, 20 May 2013 09:01:01 -0400 nicci113 2153@/discussions
Can somebody please explain why field 2 says 100% match but below is take says 202 records are not matched?? Am I missing something here? (screen shot attached) please guide me..?]]>
Search/replace: remove underscores & hyphens leaving no space? http://forums.visokio.com/discussion/2151/searchreplace-remove-underscores-hyphens-leaving-no-spaces Fri, 17 May 2013 11:29:47 -0400 nicci113 2151@/discussions
I need to do this coz my data for merge from another source require me to concatenate the text, would a space make a difference that would defeat the match/merge?

If so, how to take them out and if not then I can keep going, please suggest. Your video only suggest the simple logic and doesn't mention about removing spaces...]]>
Aggregation: Grouping records by date? http://forums.visokio.com/discussion/2150/aggregation-grouping-records-by-dates Fri, 17 May 2013 06:09:27 -0400 nicci113 2150@/discussions
Is there a way to group dates within Data Manager? I'm creating a primary key, but need the group function ?]]>
Expand Values: splitting text into multiple columns? http://forums.visokio.com/discussion/2148/expand-values-splitting-text-into-multiple-columnss Thu, 16 May 2013 12:06:11 -0400 nicci113 2148@/discussions
What logic I can use to break while putting them in new columns whose name can be defined at the later stage. I need the excel logic for text to column .

Brand/abc/yahoo/Brand/Brand - bc URL - Exact/bc com/Exact]]>