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 219

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 670

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 393

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 958

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 386

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

How do we return a member from a set? For example if I want a calculated measure to return the NAME of the date with the max transactions, to get the set ordered I might do something like:

ORDER([TransactionDate].[YearMonthDate].[Date].MEMBERS, [Measures].[TransactionCount], DESC)

But how do I access the first member in the set as a member so that I can get to the properties such as the member NAME (what I want to return in this case)?

In some MDX implementations like Microsoft there are kind of backdoor functions for this like:

0 4
0 450