Support

Refresh: Variables in file losing default opening value?

Alfonso — Tue, 16 Apr 2013 13:21:45 -0400

Hi,

In the refresh data model process, sometimes the variables loose the default or minimum value, however a message like I've attached is shown. Is there any mode to avoid this issue?

Thanks in advance,

Alfonso

Exception report: Calculation file crashing?

davedunckley — Fri, 10 May 2013 09:03:33 -0400

Hi Guys,

We have a file that performs a number of averages, however it is crashing every time. Any ideas?

Dave

Scheduler: Set a task to repeat X times after X hours?

cgamolo — Thu, 02 May 2013 16:58:25 -0400

We currently have a need to set a task to repeat one more time after a certain time period. We need to choose that a task repeat a few times using the interval period.

Printing: Font size when exporting to PowerPoint?

William — Tue, 05 Mar 2013 02:43:14 -0500

Hi - My client just recently started using Omniscope and they want to export the views to Powerpoint for presentation purposes. The issue is that the font size is really small. Is there a way to increase the font size when exporting to PowerPoint?

Thanks.

Validation: Formulae to validate incoming value format in a field?

Barcl — Tue, 07 May 2013 07:11:51 -0400

Hi - I need to check that a field contains only values formatted in a given way. For example we have a field which should contains values with the following format:
byte 1 should be alphabetic
bytes 2-5 should be numeric
byte 6 should be alphabetic
bytes 7-10 should be numeric

In order to verify that format I created a new field with the following formula:

IF ([Codice Monitoraggio]=null,null,
LEN([Codice Monitoraggio])!=10,"lunghezza errata",
(LEFT([Codice Monitoraggio],1))<"A","Formato errato",
(LEFT([Codice Monitoraggio],1))>"Z","Formato errato",
(MID([Codice Monitoraggio], 2, 4))<"0000","Formato errato",
(MID([Codice Monitoraggio], 2, 4))>"9999","Formato errato",
(MID([Codice Monitoraggio], 6,1))<"A","Formato errato",
(MID([Codice Monitoraggio], 6,1))>"Z","Formato errato",
(MID([Codice Monitoraggio], 7, 4))<"0000","Formato errato",
(MID([Codice Monitoraggio], 7, 4))>"9999","Formato errato",
null
)

I was wandering if I can find a better way to verify those values.

Do you believe it is possible to use a JavaScript based on Regular Expressions (RegEx) with the match function? I'm not a Javascript expert... I was trying to find a PHP ereg equivalent in Java?

Thanks.

Automation: File processing via Batch input/output?

cmollo — Mon, 06 May 2013 16:01:02 -0400

Is there a way to apply the same operations to a set of files?

For example, I have 10 files in a directory: file01.csv, file02.csv, ... file10.csv. These files all have the same columns (fields): field1, field2, field3. For each file I want to create a fourth field, field4, that is the sum of field2 and field3. This will create 10 new files, file01_new.csv, file02_new,csv, ... file10_new.csv in either the same directory or some other directory (doesn't matter). How do I do this?

Is there a way to run Ominscope in "batch mode," i.e. from a command line?

I looked at the Batch Append Files block... it is kind of what I am looking (in that it inputs a bunch of files from a directory) but I do not want to append the files together.

I also looked at the Batch Output block, but that did not look like what I need.

Thanks!
Chris

Database table source block not updating

martingurner — Fri, 03 May 2013 06:29:08 -0400

Had a curious case where a database table source was not loading all the rows from the table and query. MS SQL Database showed 60 rows and the datablock showed 59 rows. Update was used to no affect, block changed from Table to SQL query, and duplicated to no affect. We created a new block with the same query which solved the issue.
The block had been working previously, and spotted when the output suddenly dropped rows after a recent update all run on the iok file.

Version:
2.8-alpha b773 (09-Apr-2013 23:24:55) r80319

Table View: Sort by grouped totals?

Mees — Mon, 29 Apr 2013 11:30:13 -0400

Hi there, not sure whether or not this has been asked before but can we sort a grouped table on the group totals?
Sorting a column in a grouped table works not as expected... it sorts the underlying records (I assume).
We would want sorting the values you see in front of you, the totals...?

Thanks, A

Filtering: Group unique IDs, find conflicting attributes?

williampod — Mon, 22 Apr 2013 12:57:27 -0400

Hi All, I was wondering whether you could assist and I will try to explain the best I can as there is a fair bit to this.

I have a set of data with a "Unique ID(1)". This "Unique ID(1)" can have multiple Customers assigned to it and all attributes for the Customers under the unique ID(1) should all be aligned.

One of the attributes assigned to the Customer, is another "Unique ID(2)". I would like to filter where we have conflicting "Unique ID(2)" values under "Unique ID(1)".

So Unique ID(2) <> Unique ID(2)
This could be where the ID is populated and not equal or one is null and the other is not.

I would not like "Unique ID(1)" to be present in the report if its count is just one. In addutuib the "Unique ID(2)" is not a mandatory field, so if it is null, again I do not wish to see this.

I am able to present data where conflicting and null, but this does not meet the criteria above.

Content View: Scripting - Alert and confirm windows?

Bart — Tue, 23 Apr 2013 05:55:18 -0400

Hello guys,

I can get prompt window in Content View, why I can't get any alert or confirm windows?

Sources: Excel- Omniscope does not respond?

misakch — Wed, 24 Apr 2013 02:22:41 -0400

Hi Visokio team,

I've got serious problem. When loading the data from Excel spreadsheet, Omniscope stops working when only 50% is finished and have to be terminated. It's the matter of last few days because I was used to upload the files of the same size without problem. I've already installed the latest available build, still the problem remains.

Thanks for your suggestions, Michal

Table View: Grouping value functions options?

enrico68 — Fri, 19 Apr 2013 04:39:56 -0400

I'd like to know if it's possible to use a sort of 'formula result' option (instead of the predefined grouping value functions) in a table with option 'show summary rows for each level' activated.

Please, for details consider the example in the attached file.

Thanks

Colouring: Table View - variations to colours selected?

Mees — Wed, 17 Apr 2013 10:49:23 -0400

Hi there,

We are trying to color the rows in a table based on a value. Nothing special and it works.
However, Omniscope is not showing the colors we defined.

In the picture attached there is an example. The colored record numbers are the colors we need. We can't find the setting that provides what we need.

What we do not want is the Variation function under the Coloring button as it variates within a color as well.

Hope you can help
Thanks

Pie View: panes not oriented the same

martins2 — Thu, 11 Apr 2013 04:52:07 -0400

I have a pie view with 3 panes (please see attached picture). The order of the splits is alphabetical and the first two are orientated with the first category at 0 degrees, however the third is orientated differently. When I rotate the charts they all rotate by the same amount so I still have this problem.

Anyone know how I can fix this?

Thanks
Martin

Sources: OLAP cubes - Essbase access?

bfromson1 — Tue, 12 Jun 2012 09:59:47 -0400

We are trying to access an essbase cube from DataManager but failing at the login stage.

Latest Omniscope build is now showing more detailed diagnostic:

Using Essbase version 9.3.1

Export: Output/Publish 'Use target file' colour settings?

Mirloo — Tue, 09 Apr 2013 14:30:45 -0400

I have a Omniscope file data flow with an output file "IOK" and in advanced options "Use target file configuration". On each publish/new update the poutput file is not respecting the Data > Manage Fields configurations for colors from the previous configuration.

So, whenever I update/refresh the data in Omniscope, my colour view settings are changed in each tab?. How can I fix my configuration of Manage Fields and views of my tabs?

Thanks in advace.

Sources-Downloading Email attachments

Arunraj — Fri, 05 Apr 2013 06:39:46 -0400

Hi - I have tried to download the Email attachments through Email feed at Data Manager. Unfortunately I can't download the Email attachments but I can download the email contents

Outputs: Database Tables - field lengths?

aknotts — Thu, 18 Oct 2012 05:56:40 -0400

I have imported data to SQL Server from a DataManager database output object. Looking at the data in the database, the fields are 200 characters larger. Is there a way to make the fields size to the maximum length of the data in it? For example, in one table I have a field called [Vendor Name], DataManager has output a field of datatype nvarchar(279) in SQL Server and when I execute this statement select MAX(len([vendor name])) from tblMyTable the result is 79. I have tried this for several columns and it appears the datatype now has a length 200 more than the max data length in that field. Is this correct? Thanks- Andy

Outputs: Batch control file PDF insert behaviour?

dougmuller — Wed, 03 Apr 2013 08:59:48 -0400

Can someone please confirm what to enter in the 'Insert Behaviour' field of a batch output config file to append the PDF output to an existing file - according to the instructions in the auto-generated batch control IOK template (and Forum posting):

http://forums.visokio.com/discussion/comment/6434/)
'End' should work, but it isn't working for me (error message below).

Batch output warning: One or more files could not be published and were skipped:

Row 1:
Invalid insert behaviour "end".

Outputs: Screenshot exports...dimensions are not respected?

tamax — Wed, 06 Mar 2013 11:23:12 -0500

Hi - When we try to export screenshots using Output blocks in DataManager, and we pick a size, like 800x600 pixels in png format for instance, the exported image is always 3200x2400? We tried all formats and the exported image is never the size we picked?

We are using Omniscope Server version 2.7 build 461 x64

Thanks, Maxime

Scheduler: Time out is always 300 seconds?

naruemon — Tue, 26 Mar 2013 01:47:25 -0400

There have many scheduled tasks which some of them running on the same time. I selected 'Fork Scheduled Execution' option and set timeout for each task. Even I set timeout to '3000' but the task always failed after exceed 300 seconds. Do I need to set something? Please suggest. Thanks.

Layout: Portrait Document versus Landscape presentation?

username — Wed, 27 Mar 2013 16:03:00 -0400

Hello- I am used to only seeing Omniscope in a landscape (horizontal) orientation- wondering if anyone knows how to adjust it to become a portrait orientation? Thanks!

Analysis: Site Reach report visualisation with Venn View

JfJf — Wed, 20 Mar 2013 08:57:25 -0400

I am currently trying to visualize a Site Reach overlap report, and it has been very difficult since the data is coming already pivoted. Had anyone visualized one of these before? An ideal graph would be something similar to a Venn View report, unfortunately in this case the data is not organized by categories.

Please find a dummy data file attached in case someone would like to try.

Labelling: Re-position & wrap data labels?

nitiwan — Mon, 18 Mar 2013 11:24:52 -0400

Hi,

Are there any ways that we can move the data labels to the position we want e.g. left/right/below/above the graph? and can we make the labels showing in two lines in case the word is very long.

Thank you.

Map View: Connecting salespeople and customers?

grahamb — Fri, 15 Mar 2013 15:27:48 -0400

I have two files.
1. Salespeople with IDs and lat/long coordinates
2. Customers with Name, Salesperson ID and lat. long. coordinates

I want plot both customers and sales people locations on the same map, then draw a star map where lines are drawn between each customer and their allocated sales rep...How do I do this please?

I started by loading both files and merging on the ID. This created a file with two sets of latitude longitudes but I can only select one pair of coordinate columns for mapping?. So right now I either get a map with sales reps, or one with customers, depending on which coordinate fields I point the Map View to.

I presume that I should perhaps keep files separate but if so, is their a way to select these from the DataManager and apply to layers in some way. Or how should I do this please? Thanks

Sidebar: Show/hide filter device title bar?

grahamb — Mon, 18 Mar 2013 09:17:23 -0400

Hi. a) I have set the Sidebar to hide a filter device title bar on a variable which is fine, but how do I revert to showing it again?

b) you will also see in the image three categories - Producer, Prospect, Rep
I have added REP to the main data file to overcome the missing functionality in layer manager, but how can I sort so on the map the REP markers sit on top of the Producer and Prospect records?

DataManager: Replacing data value?

grahamb — Mon, 18 Mar 2013 06:42:01 -0400

Hi, this might be a silly question but I have a field called [AREA] that has 3 values. One of these is 'UK'. I wanted to change the values from 'UK' to 'DDMS' so created a calculation to do this. In the query I I did a test and selected a few records that were UK and these correctly appeared as DDMS. However when I do a reload 'UK' remains. How do I change this value so all views of the data analysis remain with three categories to select upon?

Pivot View: Suppressing blank values in Pivot View 2?

grahamb — Fri, 15 Mar 2013 10:11:12 -0400

Is there a way when selecting markers on a map to suppress blank rows in a pivot table? See pic

Date/Time: Reformatting dates imported as integer numbers?

grahamb — Wed, 13 Mar 2013 12:53:00 -0400

Hi. I have a date field which converts correctly from Excel and can be seen in the attached picture. I then wanted to create another field to store the month. The formulae looks correct but the result is the same for every record rather than changing. Again see picture. Any ideas? Also how would I get it to display the month name rather than a number, once the issue is corrected?

Bar/Line View: X-axis Split and Pane labels for multiple measures?

bmuller — Tue, 12 Mar 2013 18:32:05 -0400

Under the Scale menu there's an option to "Label Axes with measure names" however this only applies to Y-axis labels which is understandable given that this is in the Scale menu. Is there also an option to show/hide the x-axis label which only seems to show up when mutliple measures are selected? It would only seem fitting that this option would be available under the Measure menu.

Thanks.