Number of Sub- queries in Desktop Intelligence
This is something which I came across while designing a Dashboard report with lots of graphs, tables and pages. During the designing of the Dashboard Report, the requirement was such that I had to use sub -queries and as there were several objects which had to be used in the same and all with different filter but with the same Objects in the query panel, their was a situation where I had to use 9 sub- queries to get the desired result using which I have to make a chart in my Dashboard. In one data provider I made around 8 sub- queries but when I tried pulling the 9th one then I came to know that its the limitation of SAP Business Objects Desktop Intelligent that one can use only EIGHT(8) sub- queries in one data providers, due to which I had to change my approach.
I hope the above information will be helpful for many.
Thanks and Regards,