http://forums.visokio.com/categories/general/p13/feed.rss Mon, 30 Oct 17 17:57:38 -0400 General en-CA http://forums.visokio.com/discussion/1876/display-data-manage-fields-showhide-field-status-does-not-updates Wed, 31 Oct 2012 06:47:52 -0400 ZhouNan 1876@/discussions http://forums.visokio.com/discussion/1869/table-view-grouped-subtotals-issue Fri, 26 Oct 2012 09:25:02 -0400 dszl136154 1869@/discussions
I have a Table View grouped by a Category field.

I noticed that the subtotals are showing wrong results in certain cases.
As you can see in the attached picture that Pages per Visits (Page Views/Visits) for subtotals are wrong. The formula haven't been applied to subtotals. Instead of 8.1 there should be 2.6.
]]> http://forums.visokio.com/discussion/1854/barline-how-to-specify-measure-colour Tue, 23 Oct 2012 08:59:30 -0400 ZhouNan 1854@/discussions
I currently have a bar graph which has two Measures as show in the attachment. Both measures are based on formula specified in the Bar/Line view. I am wondering if there is any way I can customise the colour of the measures which are pink and dark blue now as shown.

Thank you very much!

]]> http://forums.visokio.com/discussion/1870/datetime-formatting-inputoutput-leading-zeross Fri, 26 Oct 2012 13:15:26 -0400 kristenjberg 1870@/discussions 1. Omniscope imported my dates (connected to a MySQL table) as text.
2. I put up the field organizer block and told it that my input format is: mddyyyy
3. I need my output format to be mmddyyyy
4. When I tell the field organizer that this is my output format it puts a leading zero in front of EVERY date, not just those that need the leading zero.

Example:
Input 1: 12141964
Output 1: 12141964 IF I tell the field organizer that the output format is mddyyyy

Input 2: 12141964
Output 2: 012141964 IF I tell the field organizer that the output format is mmddyyyy

So, I need Omniscope to recognize: if field length = 8, then do not put leading zero. if field length = 7, put leading zero.

Do I need a formula to get this result? If so, does anyone have a down-and-dirty one I can use?]]> http://forums.visokio.com/discussion/1863/formulae-help-with-syntaxs Wed, 24 Oct 2012 23:42:35 -0400 smiley 1863@/discussions "
=SUM(([Unitprice]*[Quantity])*(1-[Discount]))

[Unitprice],[Quantity] and [Discount] are my fields....

Is it possible to create formula like this? If can please guide? Thanks.]]> http://forums.visokio.com/discussion/1838/barline-view-overlapping-data-labelss Wed, 17 Oct 2012 02:04:06 -0400 shaji_o 1838@/discussions http://forums.visokio.com/discussion/1401/sources-excel-date-formattings Mon, 19 Mar 2012 11:29:28 -0400 schergr 1401@/discussions
If I change the date formatting in Excel, I get 3/14/11, but I do want the full four digit year. Am I doing something wrong?]]> http://forums.visokio.com/discussion/1866/batch-appends-raw-data-row-number-to-starts- Thu, 25 Oct 2012 12:20:55 -0400 dszl136154 1866@/discussions http://forums.visokio.com/discussion/1864/outputs-exporting-subsets-into-spreadsheetss- Thu, 25 Oct 2012 05:08:36 -0400 ZhouNan 1864@/discussions
File > Export > Create Excel Spreadsheet

It allows me to choose which fields/columns to be exported but not to select the subset of rows that come from each differnent source. Because the file contains multiple data sources, there are many unrelated and empty fields exported with the filtered-in subset which are hard for user to process in Excel.

Is there a way to export only the rows/columns that come from the same data source? ]]> http://forums.visokio.com/discussion/1861/display-limiting-visible-tabss Tue, 23 Oct 2012 21:34:21 -0400 shaji_o 1861@/discussions http://forums.visokio.com/discussion/1832/aggregation-formula-result-option-for-viewss Sun, 14 Oct 2012 23:46:58 -0400 shaji_o 1832@/discussions
However I can't see this option for graphs. Is this option available for a line/bar graph? Or any other graph for that matter?]]> http://forums.visokio.com/discussion/1857/installation-need-excel-installed-on-server-machines Tue, 23 Oct 2012 15:50:49 -0400 cgamolo 1857@/discussions
Thanks, Catherine]]> http://forums.visokio.com/discussion/1837/free-viewer-export-data-from-free-viewers Tue, 16 Oct 2012 13:31:12 -0400 kikorw 1837@/discussions
Summary: I share an .IOK file with end users with a free Viewer only license, how could they export data from the .IOK?]]> http://forums.visokio.com/discussion/1850/datamanager-custom-alerts-for-data-qualitys Mon, 22 Oct 2012 12:28:41 -0400 JfJf 1850@/discussions
For example, If I have a data stream lets say Shoe Models from sales, and I wanna cross it over with an static price excel sheet so I would be getting a merge between the Shoe Models & Shoe Prices to get my sales data. If a new model is released, it would be registered in the sales, but I need to include it In the Shoe prices so it would be successfully merged and counted; these unsuccessfully merged records would be a part of non-merged records, or in the case that I get a many:many relationship, it would be very useful to have a block or an extension of the data Validation block that would flag custom issues between blocks, so these errors could be fixed faster and easier.

In this shoes example, the solution would be IF I get less records of a particular field in the the merge output than the amount of records from that same field in a previous block, then it would be flagged as [missing records] or simply error.

It would be like adding an additional layer to the formulas that could include the Block name. So a formula which is usually [Function][Field][Record], could be [Function][Block][Field][Record]. I don't know if this is already possible, but it would be useful for data integrity and improved automation.

Thank you, JfJf

]]> http://forums.visokio.com/discussion/1848/graph-view-adding-a-custom-trendline-or-regression-lines Mon, 22 Oct 2012 07:00:02 -0400 JfJf 1848@/discussions
It would help a lot to understand patterns, and the more we could personalize that custom trendline, the best, if we could just put a formula, for example Y=5, that would create an horizontal line in the Y=5. Thank you, JfJf]]> http://forums.visokio.com/discussion/1844/barline-cumulative-values-plots Thu, 18 Oct 2012 09:29:26 -0400 ZhouNan 1844@/discussions http://forums.visokio.com/discussion/503/sources-olap-cubes-excel-powerpivots Mon, 15 Nov 2010 16:33:07 -0500 benjamin 503@/discussions
Is it possible to piggy-back off Excel PowerPivot i.e run Omniscope off PowerPivot and thus enabling 1m + rows functionality in Omniscope?]]> http://forums.visokio.com/discussion/1840/sources-batch-append-specify-data-file-header-rowss- Wed, 17 Oct 2012 10:50:09 -0400 dszl136154 1840@/discussions ]]> http://forums.visokio.com/discussion/1828/licensing-file-security-role-based-group-securitys Fri, 12 Oct 2012 05:42:26 -0400 ZhouNan 1828@/discussions
Many thanks!]]> http://forums.visokio.com/discussion/1827/outputs-exporting-to-excel-underneath-saved-worksheets Thu, 11 Oct 2012 13:57:34 -0400 SherrickChavda 1827@/discussions
Through Omniscope we are pulling and working on Daily Reports so we'd like for the data to archive and collate into one big Excel file. Any help would be greatly appreciated.

Thanks, Sherrick]]> http://forums.visokio.com/discussion/1833/outputs-files-automatically-open-on-exports Mon, 15 Oct 2012 06:53:03 -0400 davedunckley 1833@/discussions
Dave]]> http://forums.visokio.com/discussion/1816/scheduler-command-line-control-of-chained-data-flowss Sat, 06 Oct 2012 06:15:40 -0400 Alfonso 1816@/discussions
Currently, in order to refresh the Report IOK file with the end user interface I have to activate all the refresh links in the chain in a single process. What I need is a command line instruction to open, 'wait until process finish', save and close each IOK file in the chain. Someone can help me?. Thanks in advance - Alfonso]]> http://forums.visokio.com/discussion/1818/datamanager-automatically-importexport-database-tabless Tue, 09 Oct 2012 06:39:56 -0400 Alfonso 1818@/discussions
I defined a data flow like this: Open database -> organize fields -> validate data -> publish data using a database table output only. My data flow does not include a load into the blue ouput block representing the in-memory DataExplorer output for visualisation/presentation/reporting. Could we have the ability to launch this type of ETL data flow in batch mode (silent or no prompts doesn't allow the publish process run automatically)? Please if you have any ideas, let me know. - Alfonso
]]> http://forums.visokio.com/discussion/1826/venn-view-view-not-displaying-query-datas Thu, 11 Oct 2012 07:20:26 -0400 ZhouNan 1826@/discussions
On the contrary, for Bar/Line View, even if the filtered data is not the data defined in the Query, the Query data will be displayed no matter whether the result set is included in the filtered-in data set for the current tab or not.

In this case, in the tab, only the Venn diagram is using the filtered-out data. Does it mean that I need to create individual query for other diagrams on the tab to be able to use the Venn diagram; or there is any other better ways to achieve this?

Many Thanks!]]> http://forums.visokio.com/discussion/1820/refreshing-sql-server-data-auto-refresh-via-load-buttons Tue, 09 Oct 2012 08:59:25 -0400 ZhouNan 1820@/discussions
So, is it true that the auto refresh function in field organiser will not be able to refresh the latest data from database because it is only doing reloading? - Many thanks!! ]]> http://forums.visokio.com/discussion/1822/formulae-regex-extracting-subset-of-strings Tue, 09 Oct 2012 19:01:15 -0400 shaji_o 1822@/discussions http://forums.visokio.com/discussion/1821/connectors-doubleclick-sun-setting-java-apis Tue, 09 Oct 2012 09:40:39 -0400 maxgbernstein 1821@/discussions -----------------------------
Dear DFA Customer,

We understand that you are a frequent user of the DART Java API and are currently using a version that will soon be deprecated. The Java DART API, long the bread and butter of integrating with our ReportCentral service, has a large range of versions currently in use. We are going to begin enforcing a minimum version requirement on this API on November 3rd, 2012. At this time, clients must be using one of the newest versions of the Java DART API -- version 13.4, version 13.6, or version 13.8.

We recommend you take this opportunity to consider the new DFA Reporting API. The DFA Reporting API is a language-neutral REST API that offers programmatic access to the same reports as can be generated through the DFA Reporting user interface. Along with improved speed and performance, the new API will allow you to create, edit, and schedule Standard reports. We will continue to launch additional features to the new DFA Reporting API over the next few months.

Please update your DART Java API version as soon as possible to ensure uninterrupted access. If you have any questions, please email dfa-support@google.com

Sincerely,
DoubleClick Advertiser Technical Solutions

© 2012 Google Inc. 1600 Amphitheatre Parkway, Mountain View, CA 94043

Email preferences: You've received this mandatory service announcement email to update you about important changes to your DART for Advertisers account.
]]> http://forums.visokio.com/discussion/1819/outputs-showing-publish-button-in-other-tabss Tue, 09 Oct 2012 06:50:41 -0400 Alfonso 1819@/discussions http://forums.visokio.com/discussion/1802/map-view-marker-clustering-size-misleadings Mon, 01 Oct 2012 10:22:43 -0400 dszl136154 1802@/discussions
Are there any options to adjust the size of the clusters to the number of records?]]> http://forums.visokio.com/discussion/1815/connector-google-analytics-errors Fri, 05 Oct 2012 07:58:15 -0400 dszl136154 1815@/discussions
How can I resolve the problem? It affects the scheduler which results in not doing any action.]]>