Add columns to an existing report

[sreenathkm]

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

 

[nimmy99]

can you able to edit the SQL? If you are edit your SQL & its grayed out. There is a chance for incompatible objects.

 

[sreenathkm]

Hi Nimmy,

You are right, the SQL is grayed out...Can u please give me some more info on this and how to over this .

Thanks in advance

 

[pabloj]

Did you join that new table to the other entities of the universe? Stick to your guns

 

[sreenathkm]

Hi Pabloj,

Yes, I join the new table to the other entities which is a normal join.

Thanks

 

[RogerCruse]

The problem you have is CONTEXT.

Or to put it another way, run the detect context option in Designer. It should tell you what's you need to do.

Personally, I try to build universes with only one context because multiple contexts are hard work, to build & test, explain to the user and to support or change later.

Also, multiple context cause additional work to be done by your datasource.

If I can't avoid multiple contexts, then I would create a datamart of the fact tables. Thus reducing the workload of the datasource and making the universe easier to manage.

Roger...

 

[sreenathkm]

Hi All,

Just to share the solution I got for the issue:It is the Context(as few of u have already suggested)that was casuing problems.After I edited my context to include 1 more column to the join clause, my problem got solved.

Many thanks once again to one and all.