I wanted to use one info provider with all the information in it and filter in report itself to create different dynamic recipients tabs by using filters. But when I wanted to use this webi report I only see the name of the info provider and not all the tabs.
Is this correct?
So I need to created multiple info providers (which ofcourse fires several times queries to database which are almost the same only different filters)
Dynamic report tabs are not possible in Webi without using coding/SDK.
Filtering locally within Webi should be just fine, you might wanna look at Input Controls in Webi for filtering.
How large is your data set being brought back to Webi (number of rows and columns)?
Have you looked at the Publication (one pass bursting) to multiple recipients feature in Webi?
source of crystal report what needs to be published is indeed SAP BW.
But i use EXCEL as source in my bursting webi report.
and use that webi report in my publication
but the publication only recognize a data provider. So if i use one data provider for example with all countries in it and create four tabs within webi where i filter on a country. The publication does not recognize the four tabs but only the data provider with all countries
I have a similar situation where I am using Excel as the datasource for creating a Webi report. The report created fine and now trying to set up a Publication so I can burst out and send to emails within this same report.
but I am not seeing the ability to select the tab needed to bring in the email addresses?!
yes, you can only base data for a publication’s recipient from a DP. The tab “level” can’t be used. If I remember well, you can use a Excel based dataprovider for the report used to fill-in recipient but I think it is better to have data in a real table
I created a WEBI report based solely on an Excel spreadsheet. It looks good.
Now, when I try to create a Publication I get an error when trying to select this same report within the Dynamic Recipients tab. I am not able to select the tab within the WEBI Report that has the email information.
Just doesn’t make sense since this 4.1 version is supposed to be so clean… not seeing it!
Okay and again thanks for this forum it REALLY does help talking things out and getting assistance from all the GURUS here.
So far I managed to get my publication to send things out but still have bugs in it.
And it may be due to how the report is being created.
e.g.
I have a report which has some 2000 lines of data. I am or think I am breaking it per ID but when I run the publication I get 2000 emails all with 1 or couple rows of data. So I think I am missing a step somewhere I because I would only like to see all those lines grouped into the summary report I created…
:?
After fumbling around from crashes back to completing the publication I finally got it to send out reports.
But I am trying to figure out what or how to use Personalization!?
I want the report to break out based on an Excel spreadsheet but so far I am getting multiple reports(4) where I should only get 1?
(BOB member since 2006-08-23)
(BOB member since 2002-06-20)
(BOB member since 2003-05-26)
