BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Report bursting to network drive includes all the data


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
kpiracha
Senior Member
Senior Member



Joined: 23 Mar 2011

Posts: 82



PostPosted: Thu Dec 05, 2019 5:17 pm 
Post subject: Report bursting to network drive includes all the data

Hello, I searched for Burst report articles but couldn't find what was happening in my case.

I have 2 reports.

Source Report
Recipient.

In Source Report we have 'Region' as a break and that is what we need to use to burst the report.

In Recipient, we have a Region field that changes dynamically.

I have setup the publication and under dynamic recipient I have mapped the Source Report and Recipient using 'Region' field. Under destination, used the File System and entered the required info.

Scheduled the publication. It only generated one file which included all the data. Can we burst the report to destination file folder.

Do I must have the Username and Email address even when I am bursting to Destination file? Is there anything else I might be doing wrong.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11495
Location: Manchester, UK


flag
PostPosted: Fri Dec 06, 2019 4:28 am 
Post subject: Re: Report bursting to network drive includes all the data

The recipient would need to be each region manager to force the bursting, setting destination to file.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
kpiracha
Senior Member
Senior Member



Joined: 23 Mar 2011

Posts: 82



PostPosted: Fri Dec 06, 2019 9:51 am 
Post subject: Re: Report bursting to network drive includes all the data

I am totally confused about the response provided.
Back to top
kpiracha
Senior Member
Senior Member



Joined: 23 Mar 2011

Posts: 82



PostPosted: Mon Dec 09, 2019 10:31 am 
Post subject: Re: Report bursting to network drive includes all the data

Any updated on this?
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11495
Location: Manchester, UK


flag
PostPosted: Tue Dec 10, 2019 8:43 am 
Post subject: Re: Report bursting to network drive includes all the data

Sorry, been off work and enjoying a break. icon_wink.gif

If you want multiple files, you'll need multiple recipients, one for each region.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
kpiracha
Senior Member
Senior Member



Joined: 23 Mar 2011

Posts: 82



PostPosted: Tue Dec 10, 2019 9:55 am 
Post subject: Re: Report bursting to network drive includes all the data

I do have multiple recipient. Main report is broken down by Region. The second report which is called Recipient is broken by Region as well.

I don't have any Username and Email addresses in the Recipient report because the report needs to be bursted by Region into a folder and does not need to be emailed.
Back to top
kpiracha
Senior Member
Senior Member



Joined: 23 Mar 2011

Posts: 82



PostPosted: Thu Dec 12, 2019 10:23 am 
Post subject: Re: Report bursting to network drive includes all the data

Does anyone have any idea what I might be doing wrong here?
Back to top
n8aktiv
Senior Member
Senior Member



Joined: 28 Dec 2018

Posts: 83


flag
PostPosted: Fri Dec 13, 2019 10:13 am 
Post subject: Re: Report bursting to network drive includes all the data

The recipient-report should be a simple list for mapping source to target 1:1.
(Idk if a report with broken elements is working like that)

In your case, the dynamic recipient-list will only be a dummy to instruct the scheduler to split up the main-report by region.
There is no need for user or email.

In the destination-filename you can insert the placeholder "region" to give every file a separate name.

_________________
------------------------------------------
SAP BO 4.2 SP6 Patch 11
------------------------------------------
Back to top
kpiracha
Senior Member
Senior Member



Joined: 23 Mar 2011

Posts: 82



PostPosted: Fri Dec 13, 2019 12:08 pm 
Post subject: Re: Report bursting to network drive includes all the data

Thanks. I actually did what you suggested already and I do see the files broken down by Region but when I open each file, it still contains data for all the Regions. So it is bursting the report with Each Region name but still contains the data for all the Regions. Beats me icon_smile.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0314 seconds using 17 queries. (SQL 0.0034 Parse 0.0009 Other 0.0272)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo