General http://forums.visokio.com/categories/general/p20/feed.rss Mon, 30 Oct 17 14:48:13 -0400 General en-CA Forgot my file password! http://forums.visokio.com/discussion/1206/forgot-my-file-password Fri, 13 Jan 2012 05:38:52 -0500 Kefsid 1206@/discussions Version 2.7: Copy aggregation settings http://forums.visokio.com/discussion/881/version-2.7-copy-aggregation-settings Tue, 26 Jul 2011 03:21:26 -0400 steve 881@/discussions Copy and paste views http://forums.visokio.com/discussion/961/copy-and-paste-views Tue, 30 Aug 2011 18:07:14 -0400 alexhoward 961@/discussions Formula for the below query http://forums.visokio.com/discussion/1199/formula-for-the-below-query Wed, 11 Jan 2012 04:47:21 -0500 rajeshbalu29 1199@/discussions The criteria is as below:
IF the ID is unique then return the weightage column
Else
Find the max value from the weightage column for the ID and display it once to the cell as it should not be duplicated again.
Please let me know if you have any clarification on my query.]]>
Drive changes when publishing an output block http://forums.visokio.com/discussion/1183/drive-changes-when-publishing-an-output-block Thu, 29 Dec 2011 11:51:35 -0500 benjamin 1183@/discussions
I have a file which is refreshed/upadated/output blocks published automatically from a server omniscope licence.

Now , the output block publishes the file to a shared drive .

Every couple of months the location which the ouput block publishes the file to changes without any user changing these settings.It appears to save the file to the users C drive.It appears to do this when a user changes and saves the file on a data manager licence and not on a server licence.

Also when you publish a file using the ouput blocks it saves it to i.e J drive (after browsing and selecting the location) say and it does not allow you to enter the full path (I.e the mapping of the J drive ).

Any help would be much appreciated as this is a reoccuring problem

Thanks

Ben



]]>
Pop up graph view in Bar View http://forums.visokio.com/discussion/1185/pop-up-graph-view-in-bar-view Tue, 03 Jan 2012 05:21:04 -0500 benjamin 1185@/discussions
I was enquiring to see if it was possible to have a pop up view (Bar graph /Pie chart) when hovering over a stacked bar view or bar graph much like you can have a hover plotin map view.Currently you can get a list of records in bar viewby right clicking but i would like a pie graph/bar chart instead of the table view.

Is this currently possible ?

Thanks

Ben



]]>
Ordering a pane view in Bar Charts 2.6 http://forums.visokio.com/discussion/1182/ordering-a-pane-view-in-bar-charts-2.6 Thu, 29 Dec 2011 10:33:54 -0500 benjamin 1182@/discussions I have a bar chart which i have used a measure and split by a field.I have then also panned it on the vertical.When i go to order the bars the ordering is done by ignoring the pane.How do i acheive a ordering which takes into account the vertical pane.

Thanks

Ben
]]>
Sharing reports.. http://forums.visokio.com/discussion/1181/sharing-reports.. Wed, 28 Dec 2011 17:57:12 -0500 Kefsid 1181@/discussions
I have to create 300 confidential reports for all our staffs to show their performance and how much bonus they ll get.. It s not that difficult to create those reports but i dont know how to share these reports with them..

What should i do guys, should i send emails to all my fellow colleagues?

Sorry for not being creative and clever, all help will be appreciated!!!]]>
Version 2.7: Dual Axis charts added http://forums.visokio.com/discussion/913/version-2.7-dual-axis-charts-added Mon, 08 Aug 2011 07:31:58 -0400 tjbate 913@/discussions Version 2.7: Bar/Line View: Curve Line Smoothing http://forums.visokio.com/discussion/1179/version-2.7-barline-view-curve-line-smoothing Tue, 20 Dec 2011 16:10:32 -0500 bgrovens 1179@/discussions Batch Publishing: Adding Password protection? http://forums.visokio.com/discussion/1175/batch-publishing-adding-password-protections Tue, 20 Dec 2011 04:58:22 -0500 Kiddo29 1175@/discussions
I'm creating multiple IOK's from a batch file which I need password protected and domain locked.
For some reason, even when I specify the IOK templates password in the batch file I get the message:
"The password is not available".

Could you let me know where I'm going wrong?

Am i missing a column out in the batch file or is it just the password column needed? I checked that i had the correct password so that's not the problem. Also if I domain lock the template IOK's will that then filter down into the batch output iok's?

Thanks]]>
Filtering via Merges with lists http://forums.visokio.com/discussion/1177/filtering-via-merges-with-lists Tue, 20 Dec 2011 06:19:10 -0500 LukeWhiteley 1177@/discussions
[SOLVED: Merging in the list by the two relevant fields worked]]]>
extracting part of a specific text http://forums.visokio.com/discussion/1169/extracting-part-of-a-specific-text- Fri, 16 Dec 2011 09:47:32 -0500 dszl136154 1169@/discussions
Creative:
728x90_Banks_June_B.swf
200Credit-728x90.swf
Sandy-300x250-m3b.swf

I would like to create another column based on "Creative"

Creative:==============>Creative Description:
728x90_Banks_June_B.swf====>Banks
200Credit-728x90.swf======>200 TC
Sandy-300x250-m3b.swf====>Sandy

Any ideas how could I get this type of results?

Thanks
Darek]]>
Batch output configuration http://forums.visokio.com/discussion/1168/batch-output-configuration Fri, 16 Dec 2011 04:59:44 -0500 Kiddo29 1168@/discussions
I'm using batch output to create multiple iok files. In filter rules for the iok's with only one filter ( [Market]=[UK] ) for instance everything works fine.

But for some reason when i select multiple filters the iok's have no data in them

I've tried both of these syntax and still no joy so if you could let me know the correct way of writing the filtwers that would be great.

Filter rules:

[Market]=[UK],[Market]=[Spain],[Market]=[France]

[Market]=[UK],[Spain],[France]

None of the above work.

Thanks]]>
Sum fields in one table as input to another stream http://forums.visokio.com/discussion/1165/sum-fields-in-one-table-as-input-to-another-stream Tue, 13 Dec 2011 14:15:44 -0500 schergr 1165@/discussions
I've attached a view of the navigator. The tree on the right will result in the single row of five values that I want to sum and then use as "inputs" to a formula in the tree on the right.

Hope that makes sense, interested in your ideas.

Greg]]>
what happened to bar charts??? http://forums.visokio.com/discussion/1161/what-happened-to-bar-chartssss Mon, 12 Dec 2011 10:00:40 -0500 Kefsid 1161@/discussions
We used to have bar charts and now we dont have such a "view".. There are many blank pages in my reports.. Could you please help me?

Kefsid]]>
Summary and Granular level data http://forums.visokio.com/discussion/1162/summary-and-granular-level-data Mon, 12 Dec 2011 12:15:52 -0500 adam_varney 1162@/discussions
Sorry if this is not the best explanation for the issue but any help with gettining this data to the correct format would be appreciated

Thanks
Adam,]]>
Compound IF THEN ELSE http://forums.visokio.com/discussion/1160/compound-if-then-else Mon, 12 Dec 2011 08:55:19 -0500 schergr 1160@/discussions
IF A = 1 and B= 2 then C=1
ELSE IF A=1 and B=3 then C = 2
ELSE IF A=1 and B=4, then C=3
ELSE C=4

????

]]>
Date/Time: Weekly buckets not Spanish locale? http://forums.visokio.com/discussion/1158/datetime-weekly-buckets-not-spanish-locales Mon, 12 Dec 2011 05:19:48 -0500 jraich 1158@/discussions
Thanks in advance, Jordi.]]>
Web Start: Another data viewer problem? http://forums.visokio.com/discussion/1152/web-start-another-data-viewer-problems Wed, 07 Dec 2011 12:25:24 -0500 Kiddo29 1152@/discussions
I've got a dashboard hosted on our server and it's linked to by a jnlp file. Now for the majority of people accessing the dashboard there isn't a problem but a view are getting the attached "file is corrupted" error message. The dashboard is password protected and domain locked so would this have anything to do with it?

I've recently saved the dashboard through the 2.7 version of Omniscope so could this be an issue?
Unfortunately the error message is very vague...
image]]>
Bugi n data viewer http://forums.visokio.com/discussion/1144/bugi-n-data-viewer Tue, 06 Dec 2011 08:16:10 -0500 Kiddo29 1144@/discussions
Urgent one here.
In a couple of bar charts in my dashboard i hide the axis and also have it set to a specific metric (as you do).
Now when i upload this to the server and then open the iok via jnlp and data viewer the axis in the bar charts are now visible and the metric for the axis has changed!!

Can you let me know how to fix this asap please as i need to publish this for the client today!

Thanks]]>
free viewer http://forums.visokio.com/discussion/1141/free-viewer Mon, 05 Dec 2011 08:41:59 -0500 Kiddo29 1141@/discussions
Quick one - i can't find a link to download the stand alone version of free viewer.
Wanted to get it installed on a clients machine.

Could you send me a link to the executable if there is one please?

Thanks]]>
Menus: formula and aggregation/grouping interaction (2.7+) http://forums.visokio.com/discussion/1088/menus-formula-and-aggregationgrouping-interaction-2.7- Wed, 09 Nov 2011 06:12:14 -0500 steve 1088@/discussions
These ideas would not affect pre-configured IOK files; they would only change default settings, and hide inactive unusual choices.

  1. In the function picker, only show functions which have the same resulting data type (in the same "logical value domain") as the field they are applied to.

    Visible choices (depending on field data type):
    • Sum
    • Mean
    • Median
    • Mode
    • Minimum
    • Maximum
    • Singleton value
    • First value
    • Last value
    • (Formula result)


    Power-user hidden choices:
    • Record count
    • Empty count
    • Non-empty count
    • Unique value count
    • Unique values list
    • Range
    • Standard deviation


    You would still be able to get at the power-user hidden choices easily but would not see these by default.

    This is necessary for (3), to avoid aggregation/grouping from changing the data structure and preventing formulas from working. Formulas are defined to operate over underlying raw data, and if your aggregation changes a text field into a numeric through the use of "Empty count", the formula will most likely fail.

    This change would occur in grouping and aggregation, but perhaps also elsewhere for consistency and to remove choices which are confusing - e.g. a value labelled "Sales volume" but showing "Range" is incorrect.

  2. In the Table view, we provide a "Formula result" option for each field alongside sum/mean/etc., just like with aggregation, instead of the "calculate formulas over grouped results" precedence setting.

  3. In aggregation and grouping, we make "(Formula result)" the default for any formula field. This would include the Table view grouping, in-view aggregation, and the Aggregation operation in the Data menu and in DataManager.

    Note: While the bar view aggregates automatically, we couldn't allow choosing "Formula result", since Omniscope couldn't tell whether to sum/mean/whatever in any fields referenced by formulas. Instead, you would use the new "Formula" measure in 2.7, which allows you to write your own field-independent formula where you are required to use SUBSET_SUM/MEAN as appropriate.



This would mean that, if you have formulas configured in the underlying data, and you are rolling up a view to show the total sales per region, your formulas would re-execute by default.

However, due to the power and complexity of formulas, we would like to get feedback from our power users as to whether this would be a net-positive change. Would it reduce the incidence of incorrect configuration, for common models? ]]>
Colour both by Stack and Measure "lines on bars" http://forums.visokio.com/discussion/1136/colour-both-by-stack-and-measure-lines-on-bars Fri, 02 Dec 2011 06:54:04 -0500 dszl136154 1136@/discussions Total/Summary Value "All" http://forums.visokio.com/discussion/1074/totalsummary-value-all Mon, 31 Oct 2011 11:22:28 -0400 hgross 1074@/discussions
Thanks!]]>
Graph Charts - Hover plot http://forums.visokio.com/discussion/1134/graph-charts-hover-plot Thu, 01 Dec 2011 06:46:05 -0500 cedricb 1134@/discussions ]]> Free Viewer: Deployment options for client dashboards? http://forums.visokio.com/discussion/1133/free-viewer-deployment-options-for-client-dashboardss Thu, 01 Dec 2011 05:39:35 -0500 Kiddo29 1133@/discussions
I have a bit of a problem. I have a dashboard hosted on an extranet which a client can login to and view using free Viewer.

The only problem is that their IT department is really strict and they also sit behind a proxy server (which causes further problems) and they are currently unable to install the latest version of Java (or the version which is compatible with omniscope) to view their dashboard. After many discussions this method of providing them the dashboard is out of the question as it is too time consuming and a very large hassle.

My question is, are there any other ways to provide the dashboard to the client without them having Omniscope installed on their machines? I know they can download and install free viewer and we can send them the iok file but this isn't feasible as i need to domain lock the file and restrict access to the data manager to protect our intellectual property.

If you could let me know asap that would be great. I've thought about using a virtual machine which they can VPN to but again as they're behind a proxy server even this may cause problems.

Thanks, Tim]]>
Automatic Refresh pop up - free Viewer? http://forums.visokio.com/discussion/1125/automatic-refresh-pop-up-free-viewers Tue, 29 Nov 2011 11:21:18 -0500 elitem 1125@/discussions One of them has sent us an email to say he's getting a message "Automatic refresh - You must purchase a license to use Automatic Refresh any longer. If you already have a license, you may need to refresh your activation".

This is a very confusing thing for our clients. Why are they getting this message? can we stop this from happening?

Thanks, Elite]]>
Filtering on field value after aggregation http://forums.visokio.com/discussion/1123/filtering-on-field-value-after-aggregation Tue, 29 Nov 2011 09:22:06 -0500 Alexander 1123@/discussions
In a table view column "A" is the unique value count in a aggregation. Is there a possibility that I can filter on this newly generated value instead of the underlying values in the database?

Hope you can help. Thanks in advance!]]>
Searching these forums http://forums.visokio.com/discussion/1116/searching-these-forums Mon, 28 Nov 2011 04:41:33 -0500 steve 1116@/discussions
You can now search at the top-right using the same syntax as Google.

For example:
  • bar graph to search for discussions containing both "bar" and "graph"
  • "graph view" colouring to search for discussions containing both "graph view" (exact phrase) and "colouring"
  • colour -key to search for discussions containing "colour" but not "key".

Unlike Google, words must be exact, so you can't search for "color" and see hits for "colour".

If you can't find what you're looking for, use our Google custom search, which is configured to search the Visokio website and forums, but won't include very recent posts nor restricted (e.g. alpha-partner-only) posts. You will find an option to use Google on the forums search results page.

Feedback welcome - please comment here.]]>