DeepSee

Syndicate content 49 

Hi, Community!

I hope you know the option to use DeepSee analytics portal for Developer Community stats. You can find it in Community-Analytics menu.

Let me introduce the beta of new analytical dashboard 'Articles' Views', which is available in Authors folder.

It consists of two dashboards, first shows the running total of the views for the articles (to see the impressive growing curve).

The second shows the daily additions in unique views (to analyze the dates of spikes).

Use the filters of Author, Article name, Publishing year and year timescale of analysis.

E.g. here is the screenshot for Murray Oldfield's 3 articles:

 

Last comment 8 April 2017
0 0
129

views

+ 2

rating

Hi,

suppose a part of my mdx query is [DIMENSION].[H1].[LEVEL1].CURRENTMEMBER.Property("PROP1").

If the source property of PROP1 is also used as a dimension level somehwere in the cube, this query will return a key  to the entry in the coresponding star table.

Does anybody know how I can follow that key and display the real value value?

 

 

Last answer 3 April 2017
0 3
0

comments

361

views

0

rating

Hi!

There are DeepSee dashboards,  which make sense only when filtered.

Usually, they are used as Drill Target or New_window control with SETTINGS=Widget;FILTER=filtervalue.

Is there a way to hide such dashboard from the Catalog or/and request the filter value once it is opened by User?

 

Last answer 15 March 2017 Last comment 12 February 2017
0 3
132

views

0

rating

Hi!

There is a 'New_window' control in DeepSee Widget which opens the page in a new tab in a browser with a given URL.

With the help of this control you can open another dashboard and supply some parameters in SETTINGS clause.

Consider  I can setup in Dash1 the URL like: 

_DeepSee.UserPortal.DashboardViewer.zen?DASHBOARD=Postings.dashboard&SETTINGS=TARGET:W1;FILTER: [Author].[H1].[Author].%26[$$$VALUELIST]

to filter the widget W1 in Postings dashboard with filter [Author].[H1].[Author].%26[$$$VALUELIST], where $$$VALUELIST is some value from the listing in a widget in Dash1.

How can I spread the filter for two or more widgets?

Last answer 13 March 2017 Last comment 14 March 2017
0 1
97

views

0

rating

The >/</= etc. operands in named filters are great... except they won't work with measures ('native' or calculated - and what a boon it would be if  they could work with both). 

 

Are there any plans to add this capability?

 

And are there any plans to have a 'named filter' control within widgets that would let you change the operand?

 

Thanks.

Last answer 7 March 2017
0 1
0

comments

90

views

0

rating

  1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

  2. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days.

Thanks!

Last answer 7 March 2017
0 0
0

comments

196

views

0

rating

User interfaces such as Portal often give us multiple ways of doing a task. Sometimes we stick with habits and don't realize that another way might save us time.

Here's one that I learned by watching someone else using Portal.

Use the Search box to get quickly to a page that may otherwise be several layers deep in the Portal hierarchy. For example, suppose I want to check the status of the ECP networking:

Clicking on a match doesn't take me direct to the page (or am I missing a trick here?). Instead it gives me this:

And now a click takes me to the page I want.

Last comment 14 February 2017
0 3
142

views

+ 2

rating

I created a new class DSW.Addons.htmlViewer:

Class DSW.Addons.htmlViewer Extends %DeepSee.Component.Portlet.abstractPortlet
{

Property Data As %String;

ClassMethod %OnGetPortletSettings(Output pInfo As %List, ByRef pSettings) As %Status
{
    Kill pInfo
    Set pInfo(1) = $lb("Data", , , "Data", "Data setting")
    Quit $$$OK
}
}

It's a ZEN component and DeepSee portlet. It's immediately available in the namespace I created it in. DSW package is mapped to %ALL and to Samples, but if I try to create a widget with this portlet I get ZEN class not found error.

I need to go to SAMPLES and compile my class there to generate js file.

How do I avoid it? I want to compile it once and use everywhere.

Last answer 9 February 2017 Last comment 9 February 2017
0 2
110

views

+ 1

rating

Hi, All!

What is the calculated measure expression for the percentage of a member?

Say in Holefoods I want to see in a Cols Online sales in Revenue, All the revenue and % of Online sales for the Revenue?

I have the following:

With expression:

SELECT NON EMPTY {NONEMPTYCROSSJOIN([Channel].[H1].[Channel Name].&[2],[Measures].[Amount Sold]),[Measures].[Amount Sold]} ON 0 FROM [HOLEFOODS]
How can I add the percentage of All in Revenue for Online channel?
Last answer 25 January 2017 Last comment 25 January 2017
0 1
194

views

0

rating

My group needs to be able to monitor items / tasks, and let a non-management-portal user see the monitoring.  Is it possible to run DeepSee queries on Production items?  I feel like I should not be recreating the production environment or the task manager just so that I can query on the items that are running, and on their states (like "successful" or "send email").

 

Also, I need to log custom events for each task, and I'm running into difficulties with the task manager in this regard; hence the question about using the Production instead, but querying it.

 

Thanks,

Laura

Last answer 20 January 2017
0 2
0

comments

129

views

0

rating

How are we doing THIS year versus the same period LAST year? 
This is a common need in Business Intelligence. In fact, many design specifications for reports make use of a comparison between a selected period (year, quarter, etc) up to a certain date (for example November 15th, 2016) and a summary of the same information for the previous year (i.e. up to November 15th, 2015). 
This post shows how to implement this in DeepSee.

Last comment 9 January 2017
0 0
645

views

+ 5

rating

I am trying to create a query that returns the best and worst performing products for a given customer, based on this year's net sales versus last year's net sales, weighted by the total net sales for all of the products sold to this customer in the last two years.

I have created Last Year Net Sales (up to the last month end): AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])

This year Net Sales: AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-1]),measures.[Net Sales])

Percent change: ((AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-1]),measures.[Net Sales]) - AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])) /AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])) * 100

Last answer 30 December 2016 Last comment 29 December 2016
0 4
152

views

0

rating

Hi-

I am trying to figure out how to compare two dimension values in a MDX query such that records where two dimension values are the same will be filtered out.

To test this, I have modified the HoleFoods cube in SAMPLES namespace to have a new dimension called RandomRegion

I want to create a MDX query where the [Outlet].[H1].[Region] value is not equal to the [RandomRegion].[H1].[RandomRegion] value.

Here's the query I need to add the filter to:

SELECT NON EMPTY HEAD(NONEMPTYCROSSJOIN([Outlet].[H1].[Region].Members,[RandomRegion].[H1].[RandomRegion].Members),2000,SAMPLE) ON 1 FROM [HOLEFOODS]

For example, if the Region = Asia and the RandomRegion = Asia I dont want to show that row in my result set.

Any thoughts on how I can accomplish this?

Last answer 7 December 2016 Last comment 7 December 2016
0 2
482

views

0

rating

Hello. I'm just getting started in DeepSee, and am also a newbie in MDX.

I am looking to create a pivot table that will be used to drive a bar chart. The chart will have product classes across the bottom, and two bars per class: a calculated measure to derive Net Sales for the specified period last year, and a straight aggregation of a standard measure for the same period for this year. Ideally, this period can be chosen by the user via filters on the dashboard, and it could be week, month, or quarter. So, obviously, it's the calculated field (and perhaps the entire MDX query) I need help with.

My current query, which is just returning the product classes and the net sales (CLineExt), looks like this:

SELECT [Measures].[CLineExt] ON 0,NON EMPTY [WebCat1Desc].[H1].[WebCat1Desc].Members ON 1 FROM [INVOICEDETAIL]

The above cube, InvoiceDetail, also has an InvDate dimension, as well as 4 other dimensions derived from it: InvYear, InvQuarter, InvMonth, InvWee

Last answer 6 December 2016 Last comment 9 November 2016
0 1
240

views

0

rating

Enterprises need to grow and manage their global computing infrastructures rapidly and efficiently while simultaneously optimizing and managing capital costs and expenses. Amazon Web Services (AWS) and Elastic Compute Cloud (EC2) computing and storage services meet the needs of the most demanding Caché based application by providing
 a highly robust global computing infrastructure.

3 9
0

comments

4114

views

+ 14

rating

Dear All,

From my web page, i am passing filter values to mdx query.

when mdx executes, i am getting Error #5001: Invalid member expression: empty name(2).

when i try the same in samples namespace (patient cube). I got the same error.

Below is my sample MDX from patients cube.

SELECT 
NON EMPTY %KPI("PluginDemo","HighScoreCount",,"%CONTEXT") 
ON 1 
FROM [PATIENTS] 
%FILTER %OR([HOMED].[H1].[ZIP].&[32000])

Result: 0   This works fine.

 

SELECT 
NON EMPTY %KPI("PluginDemo","HighScoreCount",,"%CONTEXT") 
ON 1 
FROM [PATIENTS] 
%FILTER %OR([HOMED].[H1].[ZIP].&[32006])

Result: 13   This works fine.


Now, when i try to access both 32000 and 32006. I got error

Last answer 30 November 2016 Last comment 1 December 2016
0 3
163

views

0

rating

When creating a filter located on a dashboard that targets all, is there a way to narrow that filter down?

For example, in our data we have some dates that are well out of range due to data quality issues, but they still appear in the drop downs. Is there a way to say, only make available the below dates in the filter?

Another example, If we want to only look at Emergency data, it still provides all the wards for inpatient activity and activity in other hospitals, meaning, to get to just the Emergency wards you have to scroll through everything?

Hope that makes sense.

Also, to follow this up, is there a way to order the drop downs? as for dates the oldest dates generally appear to be at the top where as we would prefer it to start with the most recent dates.

Last answer 23 November 2016 Last comment 23 November 2016
0 4
165

views

0

rating

I currently have an MDX query/calculated measure as per the below:

 
[DaysOnListRange].[H1].[DaysOnListRange].&[Days 91 - 180]+ [DaysOnListRange].[H1].[DaysOnListRange].&[Days 181 - 365]+
[DaysOnListRange].[H1].[DaysOnListRange].&[Days 365+]

however it currently doesn't sum when there is a blank in the data.
How can I amend this query to include empty cells/only sum cells with data?

I've tried using nonempty but it doesn't appear to work in this context

Last answer 21 November 2016 Last comment 22 November 2016
0 3
195

views

0

rating