Reports dependent on datamart

[bo5i]

Hi,

How can we asscoiate a datamart to a report. My report has information coming from data mart. So i need to run datamart first to refresh the data and then execute report.

Thanks
Sanjay

 

[chael]

sure...just create a sample datamart first, model in the column headers etc., and then use the same shell to populate your reports later. This should be pretty straightforward.

Chael

 

[bo5i]

I have my datamart into the project and also have respective objects pointing to this datamart. My report uses these objects and also other objects in the project. I want to run the datamart before i run the report sothat datamart gets refreshed with latest data.

 

[chael]

I think you need two similar reports -- one to populate the datamart, one to 'read' the datamart. I don't see where your troubles lie...you seem to have it figured out.

 

[entaroadun]

It sounds to me like you want to trigger the data mart to run automatically every time you run the report. If this is the case, I'm not aware of any setting or code you can implement on the I-Server side to listen for requests of one report ID to trigger the execution of a different report.

 

[nlim]

do you want the datamart to refresh for EVERY time someone runs the report? Somehow that seems to defeat the purpose of a datamart table. Maybe other reports use the same datamart table?

If the datamart is only for this report, then you might want to just build the datamart metrics definitions into the final report for your users. Writing stuff into a datamart table, and then querying it would be similar to the multi-pass SQL that the report would generate.

 

[bo5i]

entaroadun and nlim, you are correct. i have to run my datamart every time when i have to run my report. I agree as you said that it defeats the basic urpose of datamart. i am using this datamart as one of those multipass SQL and using the metrics generated in the report. I am looking for triggering the datamart whenever i run the report.

Thanks

 

[bo5i]

nlim, this could be a good candidate for your WISH LIST. I see a great advantage with this feature(triggering datamart from a report to utilise the objects created by datamart in the report) in the tool.

Thanks

 

[nlim]

it might be a good wish list item...I'll let the gods at the company decide. But in terms of your current situation, why not create the reports in such a way that does not use the datamart table. You'll have one less "report" to maintain.

For example, if your Datamart has these columns

A1 A2 M1=count(x) M2=max

and your final report is

A3 Sum(M1) Sum(M2)

You can create the same effect by defining your sum(M1) metric as

sum(count(x){A1,A2}) {~}

and sum(M2) would become sum(max{A1,A2}) {~}