sreenathkm
IS-IT--Management
Being new to the BO environment,would seek solution/suggestions to my below problem:
I have a existing report running well in production, now wanted to add few more columns from a new table(class)to the existing report..so have added the corresponding classes from the universe and dragged the columns(objects) to the results object panel..now when I see the SQL from the data provider I see 2 queries there where in the 1st query is with all the columns from the earlier query and the 2 query having the columns added recently..does this sound logical or am I doing a mistake here.Point to note here is my report runs for almost 3hrs as it looks into massive fact tables having around 330M records.
Any suggestions would be greatly appreciated.
Thanks in advance
I have a existing report running well in production, now wanted to add few more columns from a new table(class)to the existing report..so have added the corresponding classes from the universe and dragged the columns(objects) to the results object panel..now when I see the SQL from the data provider I see 2 queries there where in the 1st query is with all the columns from the earlier query and the 2 query having the columns added recently..does this sound logical or am I doing a mistake here.Point to note here is my report runs for almost 3hrs as it looks into massive fact tables having around 330M records.
Any suggestions would be greatly appreciated.
Thanks in advance