Maximum no. of data providers

building reports webintelligence
1

How many maximum number of data providers possible in a Web-I report (XIR3)

Thanks

avbaby :india: (BOB member since 2009-05-09)

2

I’m on XI 3.1 SP2.

As a test we created a report with 20 data providers. Although I would be hard pressed to find a situation to use 20 dps, I was able to do it.

SteveBickerton :canada: (BOB member since 2002-08-15)

3

It would help to put your question into context… why are you asking this? Why is it important in your scenario to know this?

Dave Rathbun :us: (BOB member since 2002-06-06)

4

Even I was asked the same question during one of the interview. I have used more than 20DP in one of my report but I am not sure about upper limit of no. of DP’s

pawan8785 (BOB member since 2008-09-09)

5

I heard Michael Welter talked about it in his Web-I Tips and Tricks for GBN. He said it is 100.

Jansi :india: (BOB member since 2008-05-12)

6

It also depends on your memory settings and how complex each DP is. If they are simple select statements then the 100 sounds right but if they are complex using derived tables, complex filters etc…then I have seen webi crash on just a couple of them. The more memory you allocat in the Java Console Options the more DP you can have, in theory.

mcliffordgoo :us: (BOB member since 2003-02-13)

7

It is more important to understand how to work with multiple data providers than to know the exact number / restriction. Here’s how I would answer that question:

So in this way I am … politely … responding that I don’t think this particular question makes sense (it doesn’t) and also taking advantage of the opportunity to share a success story from my prior experiences.

Dave’s Interview Tip of the Day™ :lol:

Dave Rathbun :us: (BOB member since 2002-06-06)

8

From solution providening point of view, replies are acceptable. Just wanted to knew from the point of view of technical feasibilty of a tool.
Thanks for replies.

avbaby :india: (BOB member since 2009-05-09)