General

Export: Cut and Paste from Table View to Excel

enrico68 — Thu, 27 Nov 2014 09:32:47 -0500

Our users are trying to export, using cut-and-paste, a multi-level Table View (shown in picture 1 of the attached file) to Excel xlsx.

The result obtained is in picture 2: as you can see, when copied to Excel, the detail rows mantain the correct numeric and percentage format while Total rows are not interpreted correctly: they are text and no more numeric values.

Our users need to use cut-and-paste because they would like to export also the total rows and these rows are not exported in Excel when the export function in admin menu is used.

Is there a solution to this problem? Why are the total rows are handled in a different way then detail rows?

Versions: Funnel charts and Radar View in web browser versions 2.9+?

alexandervolk — Wed, 28 Jan 2015 04:37:36 -0500

Hello,

Currently, a Bar/Line View set up as a Funnel chart doesn't display correctly in web browser version. Same goes for the Radar View as a whole.

Are these generally not supported in HTML5 browser version or are there plans to make them available soon?

Thanks
Alex

Deployment: How to publish HTML5 web browser versions?

StefanikI — Tue, 27 Jan 2015 04:56:11 -0500

Hi,

I need your help and information about the topic Omniscope on web.

I want to show reports to our clients on web. What do I need to do first?
Can you write me process of this task?

Thank you for your help!

Export: changing character set in database output?

Alexander — Fri, 02 Jan 2015 05:35:32 -0500

Hi all,

First of all, the best wishes for 2015!

We use a DataManager workflow that publishes data into a database table. Based on the situation, we adjust the publication setting (Insert, Update, etc). Special tokens like ü, ë and é are being saved incorrectly in the database.

Therefore we would like to manually adjust the charset that Omniscope uses to publish database tables.

Can you advise how this can be configured?

Bar/Line View: Daily sales compared month on month?

cristian — Thu, 08 Jan 2015 07:02:56 -0500

Hi All,
I have a bar chart displaying all day of the month 1,..,31 on the x-axis and sales value on y-axis. I would like to split the bar chart and have two bars per day where one bar displays the current month, that is latest loaded month, and the other bar displays last/previous month sales. All other months are not of interest.

Example of my data structure:

Date, YearMonth, Year, Month, Day, Sales Amount

Any suggestions on how to do this?

Br
Cristian

Versions: Web Publishing in version 2.9?

dpawley — Tue, 06 Jan 2015 10:43:33 -0500

I don't suppose the Web-Publishing aspect of Omniscope is fully functional on the latest update? I am asking as sometimes we would like to share some of our reports with users that don't have access to Omniscope and this idea is great - just doesn't work?

Any advice would be great

DataManager: Grouping blocks in DataManager?

carlosmartinmari — Mon, 15 Dec 2014 12:09:02 -0500

I'd like to keep my DataManager views much simpler. For that, sometimes in order to do a specific task we use several blocks that can be connected in a complicated way but conceptually they could be grouped in "black boxes". As for example, I could think of creating a categorization system based on keywords that in the end tag every registry with "type A", "type B", "type C", based on several searches, field manager and joins. This, although conceptually simple, can be difficult to understand at first glance.

I think it would be good for ourselves and for others to understand our DataManager views, if we could just group those fairly complicated blocks into one "black block".

Import: Load only first 1000 records?

cristian — Fri, 19 Dec 2014 08:23:49 -0500

Hi All!
I'm new to Omniscope. Is there a way to load only the first 1000 top rows of a file? When developing/testing and I don't want to work with the complete file. At the moment, I'm working with a .csv file that contains 1,4M rows just for one month and it takes forever to load this.

Cristian

Display: New fields added to show only in active (Table) View?

rng — Tue, 16 Dec 2014 05:13:13 -0500

Whenever I add a new field to the dataset, by default it is automatically added to all Table Views across all tabs. I then have to go to every view on every tab and hide the new field(s) whenever all I need is for the new field to be shown only in the current 'active' Table view.

Is there a way to get around this? Or do a 'Hide in all views' kind of action?

Thanks
Rohan

Table View: Freeze columns in a scrolling table?

ALC — Mon, 15 Dec 2014 10:50:52 -0500

Is it possible to 'freeze' the first 5 columns in a table so that they will stay visible when you scroll to the right?

Outputs: Sharing the Dashboard?

pnaarayan — Wed, 10 Dec 2014 00:26:55 -0500

How to share the final story board with the team members and management?

Please share the same.

Images: Omniscope files with Images?

Harry — Tue, 02 Dec 2014 07:46:03 -0500

Is it possible to create an Omniscope file containing images, rather than just linking to a folder containing images?

Thanks

Integration: Central list of Parameters in a file?

bfromson1 — Thu, 20 Nov 2014 10:43:17 -0500

Is it possible to have a list of parameters in a file which can be read by an Omniscope instance and the parameters then used.

Specific application is to have a list of server names in one place, then individual reports can use this list to open database connections. If server is ever changed then only one change in one file would be required.

Filtering: automatically hide all empty colums in Table View

aeastwood — Thu, 27 Nov 2014 11:06:17 -0500

Hi,

I would like to be able to automatically hide all columns which are left completely empty or full of zeros by the query currently in use in table view. For small numbers of columns it would be possible to manually hide columns, but ideally they would be dynamically hidden and restored as I changed the query (i.e. if I was changing the query/filters in such a way that unpopulated and repopulated certain fields).

If this is not possible, being able to select something like 'automatically hide this particular column if it's empty' would help.

Please let me know if such a feature already exists.

This is similar to an idea raised a couple of years ago (http://forums.visokio.com/discussion/comment/6796/#Comment_6796), but nothing from that thread seems to help me.

Thanks!

Deployment: Time out settings on browser deployments?

Alexander — Wed, 26 Nov 2014 04:27:52 -0500

All,

Clients that use Omniscope mobile, are "kicked out" after 15 min inactivity.
We think this is a good feature, yet we have some users that would like stay logged in for a longer period.

Can we disable this function? Of adapt the time slot?

Thanks for your advice.

Installation: Mac OS X 1O.10.1 Yosemite?

CeciliaFabry — Tue, 25 Nov 2014 10:30:40 -0500

hello

I meet real concerns to launch Omniscope since my Mac since the update YOSEMITE

I installed different versions of Omniscope whose last (S9u2bp7042x188b) and it does not start, or very difficult, and very often plant by completely blocking when I get to start after complete restart Mac only.

My mac: Version 10.10.1 (14B25)
2.66GHz Intel Core 2 Duo
4 GB DDR3 1067 MHz

kind regards
Cecilia Fabry

Performance: 64 GB RAM Server does not release memory to OS?

Alexander — Tue, 25 Nov 2014 05:17:06 -0500

Hi,

We have a server with 64GB RAM running Omniscope server 2.9.
During one of the tasks, memory peaks at 98%. After this task we run a diagnostics task, but memory is not released.

The performance of the Server and other Omniscope instances is slow, as the RAM keep showing up to 90%.

Any advice, what we could do? Thanks

Export: Outputing file to FTP using SSH?

Alexander — Thu, 06 Nov 2014 04:00:25 -0500

Hi All,

For a client we would like to publish an output file, directly to the FTP. Their FTP is set up using SSH. Would this be possible in using the Output block in DataManager?

Thanks.

Alexander

Formulae: bracketing values using IF logic?

kantia8 — Wed, 05 Nov 2014 17:36:21 -0500

I am trying to do an analysis where I want to rename variables if they are between at set of numbers
i.e.: if the value of [Field1] is >10 and <20, then the value is changed to something like "Page2" in the [Formula Field1]

I know how to use the operators "=", ">" and "<", but I don't know how to do in between. I looked at the bucket function, but that seems to only work for dates and not other field types?

Office integration: MS SharePoint/Office 365 (Online)

herrenbruck — Mon, 03 Nov 2014 15:48:54 -0500

I'm trying to link a data file to an Excel file stored on SharePoint 365. In the past (for SharePoint 2010), I was able to put in the URL of the file, put in my authentication information, and pull the fill into Omniscope. Does anyone know how to pull or push files to SharePoint 365? Is there a different setup needed to the address or authentication? I even tried different port #'s. I can map the SharePoint on my network drive to my computer and pull it over that way, but I'd like to put in the URL to pull or push a file to SharePoint 365. Anyone else had any luck doing this?

Thanks!!

Layout: Line breaks in Header?

DBuzacott — Fri, 24 Oct 2014 00:41:17 -0400

Is there a way to have a header (e.g. at the top of a Bar/Line view) split over multiple lines? At the moment, this stays as a single line even when its width is greater than the width of the view itself.

A screenshot showing a header wider than the view is attached (the header is left-aligned for readability).
FYI, I am using v2.9-beta b1435 which is the latest version of the software.

Thanks,
Daniel

Import: Custom Stopwords into MYSQL running in Amazon RDS?

sathish — Mon, 13 Oct 2014 05:36:07 -0400

Guys we implemented full text search in Amazon RDS for MYSQL in order to search 24 million records. In full text search, we are in a need to add a list of custom words to the "stopwords" list of MYSQL.

Could anyone help us in adding the custom stopwords (For example: 'and', 'so' ) to the stopwords list for MYSQL running in Amazon RDS Server.

Tabs: Advanced Tab Settings in browser versions?

Harry — Mon, 06 Oct 2014 07:01:27 -0400

I'm using advanced tabs option to create tabs which mirror previous tabs' filters, but when using the browser version option in 2.9 the advanced tabs no longer mirror the first? Is there a way I can keep this setting on for mobile deployments?

Thanks,
Harry.

Filtering: Dynamic record counts on filtered data?

dpawley — Fri, 29 Aug 2014 07:34:19 -0400

Hi

I have a large dataset of 400k records over 12 months, by supplier, by product, by outlets. What I would like to get to is "Product A is in 50% of the outlets, over 12 months. However in August it was in 80%" from the dataset.

I can separate out the data in a chart that ranks the products by volume top to bottom over the past 12 months. I have used Unique_Count to get the number of outlets that are stocking Product A which is great but I want to divide this number by the total number of outlets in the dataset and have it change if I was to select one month, or 2 months (i.e. filter).

Thanks

Danny

Pie View: Hide Row Labels?

mattyh — Wed, 24 Sep 2014 08:01:45 -0400

Hi,

Does anyone know how to remove the row labels from a pie view (paned by measures)? I've highlighted them in black in the image attached.

Thank you for any help

Matt

Mobile: Map view: No labels showing and no displaced markers

Alexander — Wed, 17 Sep 2014 17:06:27 -0400

Hi all,
I have a mobile dashboard with a map view. But the labels are not showing.
Next to that displaced markers is not possible as well.

Is it just not possible, or am I making a mistake in the configuration?

Thanks

Formulae: Calculating Week Start - Week Ending dates?

Panos — Wed, 17 Sep 2014 13:48:34 -0400

Hi
Is there any formula so I can get the "week start" or "week end" for each week number?
Regards,
Panos

Import: Reading in value "unknown"?

Phillipa — Wed, 17 Sep 2014 06:22:15 -0400

Hi,

We are feeding data into Omniscope from an excel file.

Some of the fields have options- yes/no/unknown

For some reason when we input the data the answers "unknown" are being deleted and treated as not answered so we cannot see which fields are really empty and which answered with "unknown".

Is there some kind of setting that we can change so that we get the answer Unknown in the Omnisope file?

Thanks
Phillipa

Filtering: Creating categories from start and end dates?

Phillipa — Wed, 10 Sep 2014 12:01:09 -0400

Hello All,

I have no experience of using date fields and need help.

Specifically, I have various types of chemotherapy that have a start date and an end date.
I need to be able to determine in which quarter a specific chemo took place. And really need separate fields for each quarter a bit like yes/no fields, as I split my data by quarters.

EG a chemo started on 01.02.2014 and ended on 14.09.2014 would be categorised in Q1, Q2 & Q3 but not in
Q4.

I have looked at buckets but can't seem to get my head around it.

Can anyone help please??

Thank you.
Phillipa

Pivot View: Sorting and Ranking aggregated records/fields?

tagarw — Mon, 01 Sep 2014 07:22:52 -0400

I have one Pivot View having one field/column named [Selected Ratings].
Please see attachment for the problem and help me with this. Let me know if you need more information.