General
http://forums.visokio.com/categories/general/p9/feed.rss
Mon, 30 Oct 17 14:44:55 -0400Generalen-CABar/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 -0400bgrovens2237@/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.
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.
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 -0400tamax2235@/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 -0500ALC2021@/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 -0400alec_webliquid2207@/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 -0400Insightgroup2229@/discussions]]>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 -0400benjamin2215@/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 -0400OmarKhan2212@/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 -0400cgamolo2213@/discussionsWhen 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 -0400DBuzacott2210@/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 -0400sfourwinds2196@/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 -0400iazcac2200@/discussionsI 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 -0400AzulMorganti2199@/discussionsThank 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 -0400OmarKhan1541@/discussionsDate/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 -0400hgross1747@/discussionshttp://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 -0500bfromson12026@/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 -0400daniel2190@/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:
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 -0400davedunckley2192@/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 -0400Phillipa2189@/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 -0400Phillipa2185@/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 -0500mburgess1290@/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 -0400SteveP2181@/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 -0400OmarKhan1011@/discussionsMap 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 -0400Pascal2152@/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 -0400Nemesis2168@/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 -0400nicci1132160@/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 -0400nicci1132158@/discussionsMerge/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 -0400nicci1132153@/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 -0400nicci1132151@/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 -0400nicci1132150@/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 -0400nicci1132148@/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]]>