Recent content by sanjaydhol

Hi, Is there any way to show the report filter condition in the report header (A->B (filter ) like this) in MSTR 7.2.2 Web while drilling from one report to the another? Another question: When I am drilling from one report, the drilled report is not opening in a new window in MSTR 7.2.2 WEB but...

Hi I am getting the error element collection is invalid because structure of the template has been changed while trying to drill to a template from a report. What may be the possible reason for this message? Please help. Thanks Sanjay

Ok I forgot to mention one thing in my last mail. I was geting the SQL query from DB2 version when I set the VLDB property tables - table creation type = 'Implicit Table' but when I try to run the query with this changed VLDB property it is giving me the following error. Report: Distribution...

Thanks a lot for the last reply. I changed the VLDB property and it solve the problem. I have another question. And most probably it is something related with the same VLDB property. I have one report generated from two MSTR project( Identical projects). One is connecting to DB2 DW (Metadata is...

Hi, Thanks for all responses that I received so far from this forum. We have migrated the project DW from SQL Server to DB2. Now after the migration we found that some of the report SQL have changed. For example we have one report which is generating the following SQL when we are running...

Hi, I have created one MSTR project using access DW. Now I need to move it to DB2 DW. Now in DB2 DW we have some different table names and some different column names. I have created a seperate MSTR project and create all attributes which have the same name as that was there in my previous...

Hi , I have a requirement of putting multiple metric in a single report. I have created different metric using some different filters. Now the filter condition is such that some of the metric may not have a single row in it. Now when I try to include all these metric and define outer join on...

Hi, I have gone through the documentation. I have created one drill map from drill map editor and I have created one template and create the drill path which is a custom type and then i set the action type as to teplate and I have given that template name there and the set name as the hierarchy...

Hi, Thanks for the help. But can you explain it more detail, or if you can send me some documentation or ref for both that will help me. Once again thanks for your help.

I am using microstrategy 7.2.0. I want to know whether I can call another microstrategy report while drilling from one microstrategy report? Or is it possible to specify / associate different template while drilling from one Microstrategy report? My second question is how to show different...