Information Broadcasting

I am using BI 7.0 to generate queries, actually we have 7 queries placed in EP as a Dashboard.now we have to broadcast all the 7 queries as a single mail..can any one tell me the procedure of doing it..i actually searched the forum also...but couldnt get the right solution.

SAP Managed Tags:
BW Business Explorer (SAP BEx)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hi,

Insert all your queries into one workbook and distribute that workbook in single file (zip) & Mail.

Regards

Pcrao.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

okk..but how do we do that..can u please give me the procedure..

Hi,

Execute one query(which you want to broadcast) and save it as a workbook(provide description ) (from save icon). And then insert remaing queries one by one by selecting insert query option (sheet by sheet).Now Finally save it as workbook(existing).

Regards

Pcrao.

actually till this i am able to do ..but after this the procedure for broadcasting would be how..where should i enter the e-mail address..i want that procedure too please...actually in BI 7.0 Administration----- Broadcasting tab we can send it that way also rite..can u give me the procedure of this alos if possible..

Hi,

For workbook broadcasting you required Precalculation server. Ask basis people to provide that. you option like distribute workbook from tools menu. If you have precalculation server then you can broadcast. once check that server in RSPRECADMIN T-code.

Regards

Pcrao.

okk will check it with basis..apart from this is there any possibility of broadcasting it in a PDF format..all the queries in a single PDF file.

Hi,

I am also not aware of that. i will check it out and tell you soon. wait for some more replies.

Regards

Pcrao.

okk thank u very much for the reply...i checked with basis and also with the T-code u sent me..when we opened that it is showing red..so wat would be the pblm..probably the server is not configured..

Hi,

Ask basis people to resolve that . Ask them to check the services(stop or start) or precalserver installed properly or not.

If all works fine then follow these steps for broadcasting :

Open your workbook~~>tools~~>distribute workbook-->it will open in new window(internet explorer). there you can see the create settings for new one. if it is allready existing just select that --> in down you can see 3 tabs.

in 1st tab you can give E-mail ids which you want to broadcast the report. and also you need to slect output format of the report as excel file and also check the check box as zip file.

in 2nd tab you can provide subject line and information do you want to pass to the users.

in 3rd tab you can give variables by clicking on CHANGE.

finally you can schedule it in background.

You can check finnaly in SOST t-code for E-mail status.

Regards

Pcrao.

HI shilpa..

To enter the mail id to whom u want to send th reports goto SCOT t-code

select systmes from menu >>>short messages and there u can give the mail ids

Also check the connection between ur BI ABAP and BI JAVA.Go to SPRO->SAP Netweaver->Business Intelligence->Settings for Reporting and Analysis->BEx Web->Integrating into Portal and check there Create RFC destination to J2EE Enginee..

REgards

Sridath

Edited by: sridath on Mar 6, 2009 9:16 AM

Edited by: sridath on Mar 6, 2009 9:17 AM

Hi shilpa,

Precalculation server is a software that you need to download from service.sap.com. Make sure that you have installed the latest version of software. Here is the path for the latest version of this software, but you need to have SAP Gui 7.10 for this. Go to service.sap.com, then

Downloads u2192 Support Packages and Patches u2192 SAP FrontEnd Components u2192 BI AddOn for SAP Gui

The one with the recent date is the latest version of Prec server.

Then you need to install it on any machine that you can access via your LAN, it can be a client machine or a server machine. How ever to install this software, you need to have Microsoft .NET framework 2.0 with service pack 2.

hope this helps.

if you have further queries, please don't hesitate to ask.

regards,

Sree.

hi,

I am sorry, I forgot to mention something else as well.

After all the prerequisites are met, and after the latest precalc server software is installed, go to transaction RSPRECADMIN, and create a server here, If it's status still shows red,

goto

Run - > services.msc -> SAP BW precalculation server. Right click and go to properties, check the box that says "Allow this service to interact with the desktop" and then restart it.

Now refresh your RSPRECADMIN screen. It should work.

If it still doesn't, you will have to check whether the system on which you have loaded the Precalculation server software has all the prerequisites. In such cases, I would recommend you to choose some other system, (would recommend you to have XP installed on that machine). Install the .NET framework 2.0 SP 2,

follow the same procedure again.

Regards,

Sree

Thank u very much sree..will give this procedure to my basis team and will ask them to install it..thanks a lot for the help..

Oki dowki,

by the way there are a couple of other settings as well that you need to make, let me know when the prerequisites are met, I would post those settings as soon as you are done.

Regards,

Sree Nair.

okk will surely let u know..once it is done..

hi shilpa,

did you find a solution for the problem that you were facing.

Regards,

Sree

I have still not found a solution for that..i have informed basis they are working on it..so taz still stand still...can we do this through WAD..is there any possibility?

Rgds

Shilpa

hi shilpa,

The settings would be the same for Web application Designer, Query designer, BEx analyzer. Once you are able to execute the query on to web, you can use any of these. So I am afraid you won't be able to broadcast using WAD untill you have your query broadcaster up and running.

What's exactly happening, have your basis people installed the PreCalculation server?, what status does it show?

If its still RED, ask them to install the Software on some other machine that has .NET framework 2.0.

Regards

Sree.

if you need further assistance, check my profile. you would get my e mail address.

sree

Edited by: Sree Nair on Mar 9, 2009 9:28 AM

As you said that pre calculation server is showing only red...and one more thing how do we execute query using WAD..can u give a brief procedure..

Hi,

For WAD also IGS server is required for broadcasting. Once ask basis people .

Check this link( IGS server):

http://help.sap.com/saphelp_erp2005vp/helpdata/en/17/86c039c7811f11e10000000a114084/frameset.htm

Please check this thread:

https://forums.sdn.sap.com/click.jspa?searchID=23249958&messageID=6066921

Regards

Pcrao.

hi,

Its actually a bit complicated to execute a query via WAD, you will have to create a web template first, then choose the desired query, and then execute it on the web. The way to execute a query would be via a query designer.

About the status of the precalculation server, Even I faced the same problem. read the previous threads posted by me. you will get the results. Delete the current Prec server in RSPRECADMIN.

Are you able to execute the query on the web. If Yes, are you able to broadcast the same query?

Lets go in a step by step manner, I am sure we would be able to solve the problem. I have faced these problems and I know how irritating it can be. Thats the reason I am trying to help u out.

Sree.

Ask a Question

Top Q&A Solution Author

User

Count