Support

Scripting: Content View - controlling table borders?

enrico68 — Wed, 21 Nov 2012 09:04:41 -0500

I'd like to know if it's possible to change the border type for tables in the Content view or if the "border = n" is the only parameter available to define different border types. In particular, using scripting, is it possible to define plain or dotted or dashed border using standard html definitions? And how to apply different border type to different parts of a single table (to separate totals from details, for example)

Thanks

Variables: Error(s) trying to restore variable values?

swallace — Thu, 29 Nov 2012 11:54:26 -0500

Hi there

I've got an iok file with a couple of tabs and a category variable that is used to define the values to be shown in a couple of charts. I recently removed a few choices from the variable and now when I move from one sheet to another I get the above error message referencing a choice that I've removed. Does anyone know if this is a bug or whether it's likely the variable (and the choice I've removed) is hard-coded somewhere obscure, and if so does anyone have any suggestions where to look or how to debug it?

Thanks!

Scott.

Date/Time: Excel import - dates parsed as numbers?

tommyc — Fri, 30 Nov 2012 10:50:00 -0500

I perform an update each month with newly refreshed data set (.xlsx). I have some column headings that are dates (3/1/2010 going all the way to 9/1/2012). Most of those column headings are parsed correctly as dates, while there are others that are being parsed as numbers (41000, etc). I have checked the source to ensure the columns are formatted as DATE and have even reverted back to the previous version of Omniscope (I just updated it), and it's still happening. Any assistance would be greatly appreciated. Thanks!

Merge/Append: Appending null files?

Maty — Tue, 27 Nov 2012 04:26:28 -0500

Hi - I am executing multiple operations to various inputs that are ultimately to be appended. It may happen that some incoming data do not meet the validation requirements such that for at least one input block, no valid records are delivered. Having one null file/input block causes an append operation problem and consequently no records at all can go through. Please see the screenshot attached. I still need the input coming from the valid, complete input blocks. What can I do? Cheers, Matylda

Scripting: extracting specific token in text string?

naruemon — Mon, 26 Nov 2012 04:13:53 -0500

Hi,

I have the data like the following:
-----------------------
index information
1 A,B,C
2 A,B,C
3 A,B,C
-----------------------

Is that possible to get the data in specific token using the separator ','?
The expected result is:
-----------------------
index information
1 A
2 B
3 C
-----------------------

I tried with SCRIPT function but get the error 'sun.org.mozilla.javascript.internal.InterpretedFunction@554eef31'

------------------------------
SCRIPT("
function getToken(sVal, iIndex, sDelimiter)
{

if (sDelimiter.length > 0)
{
var aSubString = new Array();
aSubString = sVal.split(sDelimiter);

if (iIndex > aSubString.length
|| iIndex < 1)
{
return null ;
}
else
{
return aSubString[iIndex - 1]
}

}
else
{
return null ;
}

}
"

, "sVal", [information], "iIndex", [index], "sDelimiter", ",", 50)
------------------------------

Please kindly suggest. Thank you.

Omniscope v.2.8 build 414

DataManager: Copy & paste text inside blocks?

sherriff — Sun, 12 Feb 2012 06:20:45 -0500

I often find myself having to manually type URLs and other complex strings into Omniscope DataManager Source and Operations blocks, such as:

Source>URL and
Operations>Text mine>Entity extraction.

Is there a way to enable Cut and Paste to save time and typing errors?

Date/Time: Adding 10 min to a date/time value?

sara_llamasoft — Fri, 23 Nov 2012 10:57:56 -0500

Hi Folks - I'm probably missing something obvious, but here's what I need to do (working in US dates here):
- I have a date field [RouteDate], e.g. 8/12/2012 (Aug 12)
- I have a time field [StartTime], e.g. 12:45 (assume 24-hour time)
- I want to combine these into a date-time field and add 10 minutes, e.g. 8/12/2012 12:55. I'm trying to create a shipment delivery time window. Of course, I want this to be time-date math, so that if the time were 23:55, my new value would be 8/13/2012 00:05.

I tried many combinations of DATEADD, DATEVALUE, TEXTTODATE but nothing seems to yield the date-time value I'm after.

Any ideas would be most appreciated.

Cash Flow Statement

nuriozlu — Thu, 22 Nov 2012 12:44:26 -0500

Do any of you preapered a dynamic cash flow statement with omniscope ? i need to do it. i have numerous report for recievables and payables with diffrent formats.
i am wondering if i can manage it ? are there any experiences about it? demos? samples?

the hard part is putting them all together, and construct a view of how much recievables do we have and how much payables also in the same dashboard.
hopefully looking for your support
regards
Nuri

Bar/line Graph Y-axis maximum value

bmuller — Mon, 19 Nov 2012 23:45:23 -0500

Hello,

I'd like to know if it's possible to specify a maximum y-axis value like in Excel. For example in the following graph I'd like to have the y-axis maximum value range be 100 instead of 60. Is this possible to do this without having to add a fake data point at the end of the graph?

Regards,

Brian

DataManager: Automatic Removal of Excel output blocks?

benjamin — Tue, 20 Nov 2012 16:24:00 -0500

Hi - I have Excel data output blocks defined mid-stream in a DataManager data flow prior to loading a transformed data set into the Omniscope in-memory block. I also have two(2) Excel output blocks connected below the Omniscope in-memory block.

Every time I save and then re open the IOK file later, on the re-opening refresh the file always says it has removed these output blocks. Why is this and how do i stop it ? My version is Omniscope 2.7 stable release

Thanks, Ben

Date/Time: Day of week changing?

ALC — Wed, 14 Nov 2012 12:27:08 -0500

I'm trying to build in the day of the week into my report however there seems to be something weird going as the days appear as Sunday, Monday and then Sunday again when a new month starts. I am trying to make the change in a Field Organiser within DataManager

Any suggestions on how I can fix this?

Thanks, Anna

Table View: sort by grouped subtotals?

Alexander — Sun, 11 Nov 2012 10:52:51 -0500

Hi - I have a Table View in one of our dashboards. I would like to sort the rows in the table on a numeric field. This functionality works fine. But now I need to sort the table on the grouped subtotals. This does not work like I hoped.
Am I doing something wrong or is this not possible? Thanks!

DataManager: "Error on line -1: Premature end of file"?

Alexander — Sun, 11 Nov 2012 10:14:31 -0500

Hi All - When opening DataManager files, we get an error message: Error on line -1: Premature end of file. We are using version 2.7 build 445. Please advise what to do. Thanks!

Aggregation: DM block - single average record unweighted?

ygulla — Thu, 01 Nov 2012 14:11:54 -0400

Hi, I've encountered a problem with the DataManager aggregation block.

I need to aggregate all records into one "total" row. Field A needs to aggregate as an average weighted by Field B.

When I drop in an Aggregation block, don't select any splits and the choose function for Field A to be mean and the weight to be Field B. The resulting value is unexpected... the result seems to be an unweighted mean?

NB: to make it work I had to add a constant field One (equals 1 for all records) and "split" by it.

See attached file for a trivial example.

Edit: I use 2.7 b441 x64

Outputs: Add/insert rows to database tables?

earheart — Fri, 09 Nov 2012 11:21:08 -0500

I am trying to use omniscope to insert records into a database. However, when using the omniscope block, I cannot figure out how to add a record. Currently, I have a union to a row of nulls which will allow me to add one record at a time (however, it will create a null row if the change is just an update).

Am I missing something?

Sources: Execute URL in email to download data?

cgamolo — Tue, 21 Aug 2012 17:47:28 -0400

Hello,
I'm looking to pull a CSV report from a URL link in an email. Not sure if this is possible? I have already setup my email connector and this works fine. In the body of the email is a link to a report that will open a CSV file. Is there a way to execute that link and pull the data? Are there alternatives?

Time series - x-axis does not display the entire period

TTWB — Tue, 30 Oct 2012 11:02:16 -0400

Hi
I'm pretty new to Omniscope, so sorry for my newbie question.

I'm working with time series, one variable (for the simplicity...) on a weekly level. Question is: My x-axis does not show the timeperiod from my datafile (xls). The Omniscope graph starts the data in week 1, instead of week 30 as in my excel file. See attached screendump. How can I fix this.
Thanks for your time

Filtering: Changing multiple tabs?

kmatrix999 — Thu, 01 Nov 2012 10:23:03 -0400

I have a file that includes multiple measures for 50 products for 53 countries.

I want to set up a dashboard for each product (50 tabs), which I have done by duplicating the original dashboard and then changing the product filter on each tab.

The default is for all 53 countries, but I would like to be able to select a single country and change all of the tabs simultaneously. The Advanced Tab function doesn't appear to do this for me, so any ideas how I might achieve this?

I know that I could use record filters in DataManager to produce single country files, but for demo purposes I would like to use just a single, multi country, file. I'm using 2.8 build 329 x64

Licensing: ServerPlus Export to .csv options?

bgrovens — Tue, 23 Oct 2012 15:48:22 -0400

Hi Visokio,

I have recently upgraded to the ServerPlus eddition of the software. Our end users have wanted to output data to .csv file's. However when you go to File > Export on the end users free Viewer, they are not allowed to change the filter. I'm a bit baffled ...by default the "All" selection is not set and the user can't change it. Can you verify the functionality for me? If this is accurate please, describe why it would be a problem to enable this feature? Thanks for the help.

Automation: Passing calculated parameters?

dnordhielm — Fri, 19 Oct 2012 16:53:24 -0400

I'm trying to have a value that is calculated based on a parameter and a database. I would like to use this value throughout the rest of my file.

As an example, suppose I have two tables, one where I have a list of people's names and genders. The name of the person that I'm interested in is stored in a parameter, but I'd like to be able to easily access that person's gender elsewhere in my workflow. Is there an easy way to do this? I included an example in the attachment with block notes describing my problem. Thanks!

Refresh: Controlling auto-refresh?

earheart — Tue, 23 Oct 2012 16:13:14 -0400

When we open a saved Omniscope file, it often times will do a refresh automatically. Is there any way to prevent that from happening?

Deployment: Java Web Start not working?

steve — Fri, 14 Sep 2012 11:52:51 -0400

There is a known problem with launching Omniscope Online (Web Start) if your system has Java 7 installed.

You will see "Java(TM) Web Start Launcher has stopped working". Expanding "Problem details" and looking for "Exception Code" matching "c0000417" will confirm this issue.

The problem is caused by a bug in Java 7. You should revert to Java 6, until this issue is resolved.

Alternatively, edit the JNLP file (e.g. in notepad) and remove the "codebase" attribute of the "jnlp" tag. If you are launching from our website, you will need to download and edit the JNLP file. If you are hosting your own JNLP file, you should edit the file on the webserver. This workaround may have side-effects, such as inefficient JAR caching. See attached file, which will need to be renamed to have a "jnlp" extension.

Formulae: CountIF work around?

SherrickChavda — Fri, 19 Oct 2012 06:54:04 -0400

Hi Visokio - Hope someone can help me out.

I am looking to generate a formula that can consecutively count all the occurrences of a value in another column. Maybe the attachment will help you to understand:

In Excel we have Cookie ID and the Touch Points column counts the consecutive individual events. Basically I want to replicate what is in the Excel image attachment in Omniscope.

The formula we use in Excel is below if that helps:
=IF(COUNTIF($A$1:$A$10,A1)>1,COUNTIF($A$1:A1,A1),"")

Thanks - Sherrick Chavda

Deployment: Web Start - Java Web Start Error?

TomRiggs — Mon, 22 Oct 2012 16:31:45 -0400

Omniscope Dashboards will not launch with Java Version 7 Update 6 installed. We are using Omniscope Version 2.6 b824.

Date/Time: splitting/aggregation/grouping by?

ZhouNan — Thu, 18 Oct 2012 04:48:18 -0400

Hi - I am trying to split/aggregate/group my data on Month Year (e.g. Feb 2012); but the [Date] column is currently also displaying Days (e.g. 17 Feb 2012). Is there any way to achieve this for the view splits; or do I need to create a new formula field/calculated column in the DataManager? If so, which formula is the best for that?

Many thanks!

SUBSET functions: Non-empty record count?

mohamed — Wed, 17 Oct 2012 05:34:17 -0400

I would like to calculate the number of weeks for each store where there are sales. In order to do this, I have to calculate the number of non-empty records for each store across all the weeks. I have 34 weeks. So the maximum of non empty records should be 34. I have used the following formula:

"SUBSET_NONEMPTYCOUNT([Sumofvalue], SUBSET2([Store Description],[Week]))"

Please see attached file and look at the formula "Week Count", the top value should return 34 but it returns 52. I am not sure where I am going wrong.

Please see the Pivot view, it shows the Weeks against all the stores where I see empty record, I would like to discard in the calculations.

Regards, Mohamed

Scripting: 2 Fields into multi-dimensional array?

Bart — Wed, 10 Oct 2012 11:59:14 -0400

Is there a way to get two fields into one array ? I am trying to get unique names as first element of the array and values (Subset_sum([number]),Subset([name],'uniquename')) as the second element. Is it possible? Previously to go around it I was creating field with both fields joined with a comma and then I was splitting it inside JavaScript, so I had a multidimensional array.

Import: Different behavior in identical Omniscope files/dataflows?

Alexander — Mon, 15 Oct 2012 07:11:18 -0400

Hi - When I open one DataManager data flow-containing file on my laptop and on our server, the behaviour when importing a group of files is different. Both machines are running 2.7 b441. The only difference I could come up with is that my laptop has MS Office installed, but the server has no MS Office installed.

The behaviour when running on my laptop is the desired behaviour. What do you advise? Thanks!

File Security: Save option not appearing?

dszl136154 — Mon, 15 Oct 2012 12:00:59 -0400

Hi - I copied an IOK file from our server to my desktop. I have done few changes within the file and would like to save the file. I cannot find any option to save the file. In both cases I am using the same version of Omniscope.

Where can I find the SAVE option? I attach a pic to show you what options I have.

Thanks

Formulae: Sum/Average of a unique list?

benjamin — Fri, 12 Oct 2012 12:37:21 -0400

Hi - I have a dataset with multiple records for each date,currency (i.e more than one loan per statemenet date in each currency) .Each date has multiple currencies.Each currency has a FX rate.I am trying to work out the average FX rate over a time period on this dataset for a currency.I have got the function down to subset_uniquelist but omniscope can not take the sum or average of this as it is text.I am not be able to convert this to a value string which can be passed to the avg or sum functions.

The reason i need unique list rather than the entire subset is because there are multiple loans per date per currency and the number of loans per currency at each date varies depending on whether they pay their loans or not.For instance GBPEUR 1.22 say 30/09/2012 and GBPEUR 1.19 on the 31/08/2012 now i could have 80 loans on 30/09/2012 and 20 on the 31/08/2012 which would get one answer or i could haev 20 loans on the 30/09/2012 and 80 on the 31/08/2012 taking the average of these would produce differenct (and incorrect answers).I would just like the simple arithermtric average of (1.19+1.22)/2

Have you got any ideas how Omniscope can do this ? Thanks Ben