I think the problem is that you use calculated measure for the measure with the same name - f.e. count.

To solve this introduce the measure for Count with another name, f.e. CubeACount and use calculated measure to use this measure in the expression.

Hope it helps.

Hi, Amir!

Have you looked at the recent article from Alexander Koblov related to collations? I hope it has some answers on this topic.

No, you don't need gulp to use it. Gulp is used to make releases.

To use it on your  server do following:

Install MDX2JSON first.

1. Download Installer.cls.xml (from MDX2JSON folder in repository or releases page) and import it into any namespace)

2. Run in terminal (import namespace) under user with %All role:

   Do ##class(MDX2JSON.Installer).setup()

It will create MDX2JSON Namespace, will create /MDX2JSON webapp, make MDX2JSON package mapping to %All.

Check server:port/MDX2JSON/Test  that installation was successful.

Then download the recent DSWeb release and install it.

How to install:  download installer. Import it to any Namespace (f.e. User).

Run:

d ##class(DSW.Installer).setup()

It will create webapp, folder and will install the client.

To update DSW, run:

d ##class(DSW.Installer).update()

Hi!

You can make it with ParallelPeriod keyword.

F.e. let's take sales in Samples for the Holefoods cube.

To show YearToYear monthly growth in percent add in the pivot calculated measure "YTY growth" with expression:

(DateOfSale.CurrentMember-ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember))/ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember)

And format: ##.##%

How to use it. 

Place months in a pivot in Rows. Add YTY Calculated Measure to Cols. And add any Measure you want to compare into Measures, f.e. Revenue. 

You'll get following MDX:

 WITH  MEMBER [DateOfSale].[SelectedYear] AS '[DateOfSale].[Actual].[YearSold].$VARIABLE.Year' MEMBER [MEASURES].[YTY growth] AS '(DateOfSale.CurrentMember-ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember))/ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember)',FORMAT_STRING='###.##%' SELECT NON EMPTY {[Measures].[%COUNT],[MEASURES].[YTY GROWTH]} ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HoleFoods]

See the result:

And here are 2011 and 2010 together to prove the measure above works properly:

Hope that helps.

Hi, Scott!

Have you seen Activity Monitor? There was a post about it.

Andrew, I edited your post and deleted all page script from it.

Please attach it as a file to a post or send a screenshot!

Thank you in advance!

Hi, Sylvian!

We used another approach to this problem and find solution which our customers use in production.

Customers wanted sophisticated excel reports from DeepSee. Thay alredy had hundreds of predefined reports in form of Excel.

What we do:

1. Transform this standard Excel reports into excel-xml(save Excel as xml) templates with XSLT variables inside.

2. Programmaticaly run reports in DeepSee, parse the result and perform XSLT transformation under excel-xml templates and data from DeepSee. You can use for this either %DeepSee.ResultSet or %DeepSee.REST.API or MDX2JSON.

3. Get the ready to use Excel reports with data from DeepSee in excel-xml form.

Here are some code examples, presentation and workthrough which are mostly in Russian (except COS).

Hope it helps.