DeepSee

Syndicate content 49 

Hi everyone! My company has a Zen ERP application with CSP delegated authentication. Now, we're developing a separated BI application, using Angular, which consumes DeepSee REST API services. Both applications access the same Caché database.

How to implement single sign-on strategy in order to allow an already authenticated ERP user to access DeepSee REST services? Has anyone already implemented something like that?

Thanks in advanced.

Last answer 10 October 2017 Last comment 11 October 2017
0 3
268

views

0

rating

Hi, Community!

How can I manage to show in MDX query months where every month shows the value of the last month?

Say, in HoleFoods the query:

SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HOLEFOODS]

will show me the sum of revenue per month.

This query:

SELECT NON EMPTY [Measures].[Amount Sold].MAX ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HOLEFOODS]

will show the Max revenue in a day for the given month.

But what MDX will show the months with the revenue for the last day in a month?

 

Last answer 5 April 2017 Last comment 8 October 2017
0 0
635

views

0

rating

Hi, folks!

When you deploy DeepSee solutions you often do not want grant a User  %All Role to work with a particular Dashboard.

Consider a Dashboard 'Dash' with a few widgets where listings are being used.

If you manage a Role to get access to the Dash you need to grant access to %DB_DBNAME resource to have a database access,  grant access to a Dashboard resource (if any) and ...  grant SELECT accesses to all the tables involved in SQL queries being used in all the listings of widgets.

And every time(!) when you update a listing you need to rearrange that access level in a Role (either grant new or revoke not used anymore) to the tables.

How do you manage that? Manually? Or you have a magic shortcut script or recipes in hands? Would you please share? 

Last answer 28 September 2017 Last comment 28 September 2017
0 1
149

views

+ 1

rating

I have a main page in .NET where I call a Dashboard created in DeepSee like this:

<iframe src="../..zen?DASHBOARD=NameofDashboardKpi1.dashboard&EMBED=1&CacheUserName=&CachePassword=" 

to display the Dashboard in the .NEt page.

 

My problem is that connection to every Dashboard takes a while, so performance is low.

Any suggestion?

Last answer 2 September 2017 Last comment 25 September 2017
0 2
170

views

0

rating

System Monitor is a flexible and highly configurable tool supplied with Caché (Ensemble, HealthShare), which collects the essential metrics of the operating system and Caché itself. System Monitor also notifies administrators about issues with Caché and the operating system, when one or several parameters reach the admin-defined thresholds.

Last comment 20 September 2017
2 2
643

views

+ 1

rating

 

My scenario is:

 

I have a Cache method that

call a REST -> JSON -response  > INSERT/UPDATE the source table of a DeepSee Cube -> Update the Cube only for this change -

I want to view in .NET Application the changes. For that I want that this method should be executed at a defined interval.

Or maybe the solution is a Refresh button in .NET page. is there any way to access a Cache method from .NET?

Any idea how to do it?

 

 

Last answer 8 September 2017
0 1
0

comments

166

views

0

rating

Hi, Community!

If you do not know much about DeepSee technology, this video on is exactly for you:

DeepSee Webinar

 

0 1
0

comments

94

views

+ 1

rating

Hello, I've completed this tutorial: https://community.intersystems.com/post/deepsee-period-date-vs-same-peri...
I've used the "year" level instead of a pivot variable.
I want to calculate something like the following variation: 100 * ([DateOfSale].[PTD] - [DateOfSale].[LYPTD]) / [DateOfSale].[LYPTD]
I create a new calculated member, under the same dimmension with the above expression.
I put the new calculated member under the Count measure and it tells me that "Two measures cannot be crossjoined"
What am I doing wrong?
Can you redirect me to some explanations and maybe a solution?
Thanks!

Last comment 31 August 2017
0 3
0

answers

164

views

0

rating

Hello,

I have a series of data organized by time (year and month) so I can use a time dimension to drill down data. So far so good.

However, I need to display the data not by calendar years and months but rather by seasons. The season has 12 calendar months but starts in September. So I'd like to see the data from September / Year N to August / Year N+1 using the same hierarchy as normal time dimension.

Has anyone done something similar?

Obviously, the season can start by any month, not only September :)

 

TIA!

Last answer 3 August 2017 Last comment 3 August 2017
0 1
131

views

+ 1

rating

My boss would like to change the Ensemble logo that one sees in the mangement portal, because it's part of the DeepSee Anaylzer.  

 

I can see where it lives on the generated html.  

I kow that you can set the logo for the User POrtal settings in DeepSee -- you can specifiy a URL for your logo.  But we'd like to go one stee further and change the Ensemble by InterSystems to our own logo / company name.  

Is it possible to change this in the code?  Is there a Configuration setting to change this?

Thanks,

Laura

Last answer 2 August 2017 Last comment 2 August 2017
0 1
231

views

0

rating

How can I localize arbitrary column name in DeepSee pivot?

If a column name is a dimension or a measure I can localize using architect following this guide.

But what about some random string?

I have tried setting:

  • Value
  • $$$Value
  • $$$Value/MYDOMAIN

as a Caption, but every option simply displays as is.

Last answer 12 July 2017
0 2
0

comments

108

views

0

rating

Hi everybody, 

I have to create a pivot that shows the result comparing the last week of the current date with the last week of the last year in the same month. I tried using the function LAG, but didn´t work.  Works only if I want to compare the months between the two years.  If someone has some idea, i will appreciatte a lot. 

Thanks.

Jaqueline Krieger

Last answer 4 July 2017 Last comment 4 July 2017
0 3
139

views

0

rating

It was InterSystems hackathon time and our team, consisting of Artem Viznyuk and me had Arduino board (one) and various parts of it (in overabundance). And so like that our course of action was set - like all other Arduino beginners, we decided to build a weather station. But with data persistent storage in Caché and visualization in DeepSee!

Last comment 8 June 2017
0 7
1083

views

+ 12

rating

Hi, colleagues!

Suppose you have large set of cubes, pivots and dashboards in your DeepSee solution.

Then you  change the level, measure or dimension in the cube and is there any way to test that your new input didn't  break current pivots, dashboards, etc?

How to test this?

How do you test your DeepSee solutions?

 

Last answer 18 May 2017 Last comment 20 May 2017
0 4
138

views

+ 1

rating

Introduction

We used the InterSystems iKnow technology to create a review assessment system called iKnow Reviews Analyzer (iKRA). Some information about the prototype of the system can be found here. iKRA analyzes users’ text reviews and automatically rates the object being reviewed. This functionality may come in very handy on e-commerce sites, forums or collections of media content – in other words, everywhere where people discuss products, places or services, for example.

 

What does the solution do?

Last comment 10 April 2017
0 0
353

views

+ 4

rating

Hi!

Sometimes I need to filter the widget on a dashboard from a different cube. And I face the following problem:

Widget A refers to a query from Cube A and I want to filter Widget B from Widget B.

Widget's B pivot refers to Cube B, and which has different dimensions for the same data.

E.g. cube A has the dimension Author and the Cube B has the dimension Member for the same data. So  there is no way to filter such a widget B from the widget A.

Actually, once we filter a given widget B with another widget A, we add the Filter Expression to the MDX query which looks like member's expression from Cube A, like:

[Outlet].[H1].[Region].&[Asia]

Is there any way to alter the filter expression for Widget B, just changing the value of the last part (Asia in this case) of the filter expression?

Last answer 9 April 2017
0 0
0

comments

127

views

0

rating