on 08-25-2005 9:44 PM
Hi Guys..maybe a stupid question.. but how exactly are the workbooks used ? Eg: I have a company template on top, with fonts and stuff in sheet1. Does that look replicate in all of my sheets in that workbook ? When I try to insert another query in sheet2, I don't have that template in sheet2 but only in Sheet1. Is that how it should be or the look should be replicated in all the sheets when I insert query ? Please advise. Also, are there any sample workbook templates available anywhere ? That will be pretty helpful.
Thanks
Hi BBM,
"When I try to insert another query in sheet2, I don't have that template in sheet2 but only in Sheet1"...this is how it works. Usually we do a workbook template for the simple one query and one sheet workbooks. For the others where you need more queries on different sheets, the formatting is done as per the case. I can try to send you a sample if your provide your email ID.
Hope this helps...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sree,
Thanks for your input. Actually I know those options, but wasn't sure exactly as to how it would look once I have my queries embedded like I had posted above. I am planning to insert a bunch of queries in a workbook and wanted to see if the template would be across all the queries or not.
Bhanu, I will wait for your mail.. Hopefully that example will clear my doubts.
Also, ,Is it a common practice to have like all your VBA functions in the first worksheet which then drive the other queries embedded that workbook ?
Bhanu,
I tried the template. I noticed that there are bolded overall results and other items in the results area. Is there any spcific way to do that ? I couldn't figure out formatting to that extent where I could reflect anything in the results or header/filter area. Also, anything that I could do for Hierarchies and indents ? Please advise.
Thanks
Hi BBM,
You can do the different kinds of formatting in your workbook with the help of the Format button on the Bex toolbar. Do not use the excel formats for the Bex celss as these options can be overwritten when the results are refreshed from the server. Put your cursor on the cell you wish to format and then click Format and make changes are required. Bex works on the concept of format templates, so any cells that bearrhe same Bex style will be affected by the changes. This is where it differs from Excel formatting which can be cell by cell. To see the style assigned to the current cell, in the Excel menu Format > Style. Here can see values like SAPBEXchaText etc, depending on the cell selected. So eg. if this cell is made Bold, then all cell with the style SAPBEXchaText will become Bold. You can play around and see what suits your need the best.
Hope this helps...
Hello Bhanu,
I was wondering if you could share the sample workbook with me as I am also struggling with the look and feel of it. My email id is jesjose@yahoo.com
I created a workbook template with company logo on top. But when I open up a query from the analyzer tool bar it doesn't open up in the template. I did the settings like Settings->new workbook on embed->is based on permanent template. When I open up the template and I am able to insert the query or open up the query straight from the analyzer. Is there anyway when the user open up the query from the analyzer, the query will be opened up in the template.
Thanks
Jose
Hi BBM ,
Fist you have to store you company template.
In BEx analyszer -> Seetings-> slect "NewworkBook on Embeded" -> select " IS SELECTED FROM LIST"
After executing query system will ask select work book template you can select you company tempalte work book.
second way is First you have to save your work book then copy your company format in to exsiting work book then save "SAVE EXISTING WORK BOOK".
Thanks
Sree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.