Question
· Aug 27, 2018
Order by date

Hi community,

The question that I have , it's very simple. I developed a pivot that contains two rows, the first it's a date and the other another field. I need to orde by date in descending order and I can´t find where I can do this. I saw that it's a option Sort members, but it's based in a condition of the measures.

Can someone help me with this.

Thanks in advance.

0 3
0 671
Question
· Aug 1, 2019
DeepSee security issue

Hey Guys,

Have enabled DeepSee on my cache db via

Do EnableDeepSee^%SYS.cspServer(0)

I have created user with access to a profile with all the %Deep_See options (%DeepSee_Admin, %DeepSee_Analyzer etc etc) as well as %All. I have also added %All to unknownuser

When click the DeepSee page and choose a namespace Architect, Analyzer, Reporting Data Definition and Reporting Builder are all greyed out with 'you do not have privilege to view this page

0 3
0 216

Following instructions on this page https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=D2IMP_... I am trying to create a Data Connector to be used as a base class for a cube with update support.
That page suggests that putting an SQL query inside XData block is not suitable for a Data Connector that supports updates.
Later it also suggests that to enable updates your SQL query must include

0 2
0 220

I built a dashboard to show hourly instrument capacities based on a term list. The term list consists of the TestInstrumentID and the number of tests that instrument can perform in 1 hour. The calculation works correctly and the data is accurate but periodically if you go to check the dashboard the percentages all get changed to 100% across every hour. If you check it later or add an additional site to the filter then the percentages correct themselves. I don't know what's causing this or how to troubleshoot it because it does calculate correctly but is not consistent.

0 6
0 191