tag:blogger.com,1999:blog-2615703102299902978.post3990036478479181318..comments2024-02-03T00:03:10.178-08:00Comments on Glenn Schwartzberg's Essbase Blog: The Power of Report Scripts (Part 3)GlennShttp://www.blogger.com/profile/08532634180859769798noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2615703102299902978.post-77869836311090639192009-12-22T06:43:47.971-08:002009-12-22T06:43:47.971-08:00It is not possible to do what you want concatinati...It is not possible to do what you want concatinating multiple columns together. The closest you get is the replace function that can replace one value with another. There would be a couple of ways you might accomplish what you want. First, the Jexport custom defied function would allow you to concatinate the members together, second, you could write a post processing routine in Perl or VBA (or another language) to go through the output file and make the changes. Third, you could use dataExport to export the data into a relational table then either create a view or stored procedure to do the modifications you wantGlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-65720650859425141572009-12-22T02:21:06.292-08:002009-12-22T02:21:06.292-08:00Is it possible to apply formatting to data while e...Is it possible to apply formatting to data while exporting through report scripts? Like if I want to merge two columns to one or map 4 rows to 2?Ronaldhttps://www.blogger.com/profile/12291144717546175427noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-9543553525963898562009-01-13T19:03:00.000-08:002009-01-13T19:03:00.000-08:00Hi Glenn,Your tips on report scripts are really ap...Hi Glenn,<BR/><BR/>Your tips on report scripts are really appreciated.<BR/><BR/>I found it really helpful as I was working on it from almost 1 1/2 year and your tips really helped me to speed up my work.amarnathhttps://www.blogger.com/profile/12749240552285136096noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-86354556135380654202008-08-06T14:07:00.000-07:002008-08-06T14:07:00.000-07:00Scott, The only place I know that shows the basics...Scott, <BR/>The only place I know that shows the basics of report scripts is in the tech reference. It has the basic info and sample scripts to do sa number of different types of queries. <BR/><BR/>The other option is to use query designer to create scripts to do what you want. Save them and it will create a report script with the syntax it used to generate the script. It's an easy way to see what gets generated by different statements.GlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-78974793217307033882008-08-06T13:58:00.000-07:002008-08-06T13:58:00.000-07:00Glenn. I really appreciate your tips on using rep...Glenn. I really appreciate your tips on using report scripts. I however have a long way to go in learning to use them effectively. Is there an online source I could go to or download from to get more basic info on report scripts?<BR/>Thanks again for your efforts<BR/>Scott AAnonymousnoreply@blogger.com