cancel
Showing results for 
Search instead for 
Did you mean: 

Workbook Format -Template?

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

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...

Former Member
0 Kudos

Bhanu,

You are the man. I would really appreciate it if you could send me an example. It is vindy80@hotmail.com. I

Former Member
0 Kudos

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 ?

former_member188975
Active Contributor
0 Kudos

HI,

Just sent you a simple example. Hope it helps.

Former Member
0 Kudos

Thanks Bhanu for the template. Also, with VBA could you give me some more pointers as to how feasible would be that approach and how much effort maybe involved. Also, any docs/links that you may know of. Appreciate all your help.

Former Member
0 Kudos

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

Former Member
0 Kudos

Bhanu,

Is it possible for u to e-mail the template to me at nthsri@yahoo.com

Thanks

Anitha

Former Member
0 Kudos

hi,

can i also get a copy of it to my id: torahulc@yahoo.com

former_member188975
Active Contributor
0 Kudos

Sent to you and Anita.

former_member188975
Active Contributor
0 Kudos

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...

Former Member
0 Kudos

got it. thanks bhanu

Former Member
0 Kudos

Thanks for all your help Bhanu. That was really helpful.

- BBM

Former Member
0 Kudos

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

former_member188975
Active Contributor
0 Kudos

Hi Jose,

I see that you have set new workbook on embed->is based on permanent template, but did you do the other part of this setting, i.e. make your workbook template as your permanent template?

Former Member
0 Kudos

Hello Bhanu,

If it is done on the Bex Tool Bar just below the command new workbook on embed, I have done it. Apart from that I don't know where to do it.

thanks

jose

Former Member
0 Kudos

Hello Bhanu,

Would you please share with me the sample workbook template. My email id is jesjose@yahoo.com

thanks,

jose

former_member188975
Active Contributor
0 Kudos

Sent...

Former Member
0 Kudos

Hello Bhanu,

Thanks a lot. That really helps. Thanks for all the time and contributions to this forum. I can't see any buttons to award the points.

jose

former_member188975
Active Contributor
0 Kudos

Hi Jose,

You cannot award points on this thread becasue you did not create it. You can only assign points to answers when you create a thread and mark it as a question.

Former Member
0 Kudos

Hi Bhanu

Can i get that documents which you sent to every on as we started on reporting now..

Srikanth.b@obtglobal.com

Regards

Srikanth

Answers (1)

Answers (1)

Former Member
0 Kudos

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