Saving reports and generated MDXQuery of OlapClient

[richard]

Hi,

Is there a way to save the data generated from the OlapClient like:

1. The MDXQuery and Reports be maintained in the database and can be dynamically loaded via cube selection.

2. Control the path where the exported reports will be saved

3. Control the filename of the exported reports.

Currently im using the code below to trap the events being triggered from the client.

 [AcceptVerbs(HttpVerbs.Post)]

        public ActionResult OlapClient_Index(OlapClientParams olapClientParams) 

        {

            //...trying to catch the events and data from the client-side

            OlapDataManager olapObject = GetOlapDataManger(false);  

            OlapClientHtmlResult oResult = new OlapClientHtmlResult(olapClientParams, olapObject, InitializeChartSettings());

            return oResult;

        }

regards

Richard

[richard]

Anyone?

[Prabu S]

Hi Richard,

 

We have analyzed your query and response as below.

 

The MDXQuery and Reports be maintained in the database and can be dynamically loaded via cube selection.	We have created a sample to save and load the reports from the database table. Please find the sample below. http://www.syncfusion.com/downloads/support/directtrac/112320/Save&LoadReportInDataTable1095439332.zip   Utilizing this as a core/base the entire application could be built  with entire logic allowing the report to be loaded probably on cube selection.
Control the path where the exported reports will be saved	Yes. This can be modified by providing the appropriate connection string path for the DataBase table. Please find the code behind inside the controllers as shown below.
Control the filename of the exported reports.	Yes. Report name can be modified by providing the appropriate Report Name for the report before save it. Please find the code behind inside the controllers as shown below.

 

Hope we have answered this query via our direct-trac system. And if there is any further concern please contact us through our support system itself.

 

Regards,

Prabu S.