Question JAQUELINE KRIEGER · Sep 3, 2018

 Hi Community,

  I am using a method taht calls a Dashboard in Deepsee web  from an application , but I want to know if it's possible  to not showing the header, this part that have the search button, the name of the namespace, etc..

This is the method : 

Method %OnAfterCreatePage() As %Status
{
    //Set contratistaId = $Get(%session.Data("ContratistaId"),"")
    //Set gerenciaId    = $Get(%session.Data("GerenciaId"),"")

10
0 661
Question JAQUELINE KRIEGER · Aug 27, 2018

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. 

3
0 823
Question JAQUELINE KRIEGER · Jul 18, 2018

Hi community, 

I'm in a proyect that I have to load data that cames from 3 different sources and one of these sorces is a csv file that contain the name of a switch and the name of a port. My cube have also this information, but I have to show only the values that match with this information.  I'm trying to filter the cube through this method below, the problem was  the result of the method is not only a value, it is an array with many values ​​and I must use the IN operator and not this "&" symbol. I wanted to know if it's possible or not?

6
0 446
Question JAQUELINE KRIEGER · May 31, 2018

Hi community,

I’m working in a project for a Chile Police and I need to know if it’s possible to build a hierarchy in Deepsee like Zone- Prefecture – Comisaria – Destacamentos (there are 4 levels of police units) , but these information are only in one table that has the code, the father ,description and UnitType. (it’s recursive) . Example:

UNI_CODIGO

UNI_PADRE

UNI_DESCRIPCION

UNI_TIPOUNIDAD

1

20

OTRA REPARTICION

 

10

2.380

38A. COM. PUENTE ALTO

50

20

 

DIR.NAC.SEGUR.Y ORDEN PUBLICO

10

30

8.855

TENENCIA CARRETERA ARICA

70

40

8.740

1RA. COM. ARICA (AGR)

40

45

40

1RA. COM. ARICA

50

8
0 486
Question JAQUELINE KRIEGER · May 7, 2018

Hi everybody,

 I need to load data from excel to a class in cache, but this class has foreign key and property like AS ..... (other class). This class represent an item product that belongs to a line, the line blelongs a group and the group belongs a Category. 

Example:  

5
0 1951
Question JAQUELINE KRIEGER · Mar 19, 2018

Hi community,

When I export the cube and the pivots that I made and import to another environment , the calculated metrics and dimension and also de pivot variable didn´t appear in the other environment. Because of this the pivot that use these metrics show error when you try to open. 

I want to know that this behavior is normal or exist a way that you can export everything, independent if you build inside the cube or inside analyzer.  

Thanks.

Jaqueline Krieger

3
0 443
Question JAQUELINE KRIEGER · Mar 9, 2018

Hi Community,

I have a dashboard with 4 widjets, two of them use the same filter date and the others two another filter date. I want to know if it's possible that when I selected a date in one widjet affected also the other widjet with the same date. I saw that the filter can affect all of the widjets or only one, the owner of the filter. The other thing that the client ask me, if exists the possibility to create a generic date and when the user choose the range of date, will affect all of the widjets, independent that are different dates. If it's possibly, the only way , i think, it's

10
0 517
Question JAQUELINE KRIEGER · Jul 3, 2017

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

4
0 380