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 226
Question
· Nov 23, 2019
Clearing my cube of data

Hi I am experienced with Ensemble but working in my first DeepSee project, so forgive me if this seems elementary.

My question is, how do I clear the data out? Every time I build I am adding more and more data. But I would like to revert my cube to being 0 so I can reload it and start over? Set my row count back to 0?

I am unable to remove/purge through the management portal

-I've tried to kill my cube Do ##class(%DeepSee.Utils).%KillCube("MyCube.Cube") and then Rebuild it.

Thanks In advance

0 5
0 218

I tried using the DeepSee Troubleshooting guide but the suggestions weren't working. Let's say that the source data we are using to build the cube on has a value out of range. This would cause the cube build/update to fail. How do I see the error log that explains which field has the value out of range? Please be detailed on exactly what command I should enter and where I should enter it in.

0 5
0 668

Hi, Community!

I'm using Git with DeepSee and when I need to do a commit to the git repo I'm exporting ALL the pivots and dashboards from the namespace. But I can forget to do that) And it can take time for a large system.

What is the way to manage automatical export of DeepSee artefacts which we are editing in UI (Cubes, Pivots, Dashboards, Pivot Variables, Term lists, Shared Measures) into files every time when I push Save button?

0 5
0 429

Hi all,

I have a dashboard which shows the growth of the months compared with the month from the last year.

The way I found to develop that, it was with a kpi. So, I overrode the %OnLoadKPI method with two mdx:

SELECT NON EMPTY [DataD].[H1].[MothYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2016]

SELECT NON EMPTY [DataD].[H1].[MonthYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2015]

1 5
0 392

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:

0 4
0 957

Hi -

I need an example of what I need to "map" to have a common dashboard defined so it will visible/usable in multiple namespaces.

I have created a dashboard in "SAMPLES" (namespace and database) and I would like to have this dashboard be accessable/useable from a 2nd namespace, but I'm not having any success in doing mappings (global/package/routine/data) to be able to get DeepSee to be able to see/display the dashboard.

What is the minimum that I need to map?

0 4
0 384

Hi everyone.

I have a cube with two dimensions, DimA and DimB, with the following structure:

DimA/H1/LevelA

DimA/H1/LevelC

DimB/H1/LevelB

DimB/H1/LevelC

LevelC is modeled in such way because its bound property (C) is group by properties A and B in transactional database, but A and B haven't relation.

I can use DeepSee REST API service /Info/FilterMembers/:datasource/:filterSpec specifying each dimension one filterSpec parameter and handle the results.

But, I would like to have the results for both dimension in only on service call.

0 4
1 250

Hi hi,
Is there any way to do an automated daily print-to-PDF of a dashboard (its' widgets / pivots etc)?
I am able to add a "Print" Control to a Widget on a dashboard to do the default DeepSee Print functionality of a Control, but this is manual and browser dependent.
Is there a way I can either:
1) have say a scheduled task to automatically print the dashboard (as and instead of the manual Control click) including specifying filename?

0 4
0 365

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

0 4
0 322