How can we customize the Excel content exported from the Analyzer/Dashboard ?

Question

Question

Sylvain Guilbaud · Feb 17, 2016

#InterSystems IRIS BI (DeepSee) #MDX

A customer needs to add lines in the Excel sheet before the MDX resultset content.

Is there a more elegant/convenient way than modifying %DeepSee.UI.MDXExcel methods ?

Thanks in advance.

Sylvain

Discussion (4)1

Log in or sign up to continue

Evgeny Shvarov · Feb 18, 2016

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.

2 0

score 0 · Answer 1 · 2016-02-17T15:40:47-05:00

Currently there is no way to add this customized content. Modifying the system methods in %DeepSee.UI.MDXExcel is not supported and of course any changes made there will not survive an upgrade. A request like this is best filed as an enhancment request via the WRC.

score 3 · Answer 2 · 2016-02-18T06:05:20-05:00

Thank you Daniel.

Actually I've found another way to do it without modifying any % classes !

1. using Studio, create a class which inherits from "%DeepSee.UI.MDXExcel" ; ie : "MDX.export.cls"

2. overwrite in MDX.export.cls what you need to modify to fit your expected rendering in the appropriate methods :

OnPage, %PrintListingResult, or %PrintResults ...

3. in your DeepSee dashboard,

replace the Export Excel parameter of your widget, corresponding to this line in our .dashboard.DFI definition :

by a new navigate control which calls your MDX.export class :

<control name="" action="navigate" target="*" targetProperty="./MDX.export.zen?MDX=...mdx query..." location="widget" type="auto" controlClass="" label="Export Excel" title="" value="" text="" readOnly="false" valueList="" displayList="" activeWhen="">
<valueRequired>false</valueRequired>
</control>

NB: to retrieve all the parameters of the targetProperty (MDX, FILTERNAMES, FILTERVALUES, TITLE, ... ) , you just have to first run the native Excel Export and then copy the link by using the Downloads view of your browser.

WARNING : the targetProperty length is limited to 250 characters

score 0 · Answer 3 · 2016-02-25T04:08:10-05:00

Sylvain Guilbaud · Feb 25, 2016

Thanks Evgeny ; that's a more elegant approach !

0 0