When I launch a query vie BEx ... It's possible to change the default properties of the BEx Analyzer ? For example I want to put this properties (Do not adjust column width)by default for all the queries I launch via BEx ...
As the previous responders have written, there is no way to set these properties automatically using built-in BW capabilities. I agree. But, that does not mean it cannot be done.
The only way I know to accomplish this is to write your own macro to do this. There are 3 parts to it. The easy part is setting the properties to not adjust column width. The more difficult part is making your macro aware that you have opened a workbook. Then you would need to check to see if the workbook just opened is a BW workbook, so that it can then set the adjust column width property to your liking for every query in that workbook.
I will give you the overview here. If you are interested in pursuing it, post again and I will give you the details.
The easy part first ...
To set the column width property, you go to the (very) hidden worksheet named "SAPBEXqueries" in the BW workbook, in column Q you put either a 0 (do not adjust), a 1(adjust to results area), or a 2 (adjust to entire column width).
To more difficult parts ...
To know that a workbook has been opened (so you can do the rest), you have to access an Application event. The good news is that the WorkbookOpen event is built into Excel. The other news is that to access it you need to create a Class Module in VBA. This is an advanced topic; but, not an impossibly advanced topic. Chip Pearson has a web page on this topic, if you want to read more. http://www.cpearson.com/excel/AppEvent.htm
To know if the workbook that has just been opened is a BW workbook is actually the easiest part of this (but, logically follows knowing when a workbook has been opened). Every BW workbook has a (very) hidden worksheet named "SAPBEXqueries". I doubt you will find any other workbooks with this distinct characteristic. But, if you really want to be sure, you can also look for hidden Names in the workbook ... you should find these: SAPBEXrevision, SAPBEXsysID, and SAPBEXwbID.
Is there a way to set the web report to come up in the graphical version by default when you run the query instead of coming up with the data analysis tab?
I had exactly the same question... but I don't believe it's possible to change default properties - this is according to advise from Accenture experts...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.