This content has been marked as final. Show 3 replies
Get the table name for the alias T123456
in BMM source properties->Content tab
check where clause section
If helps mark
Thanks for the reply..
I checked in both environments already, there is no conditions under Content tab where clause.
Not only in this backend query, i thought BI server will automatically generate this where conditions in all physical generated queries. but it will not differ in Results.
In this cast results also differ. Could you please let me why OBIEE generates this addtional where conditions.
Do I need to check any join conditions in rpd??
Can you post the sql's of both the environment..?..
There seems to be change in the RPD design in both the environment..If row_id is not getting restricted in the Presentation layer then definitely it is somewhere in the RPD for sure..
BI server generates query automatically based on your design how ever it never adds upa ny where clause unless you add in to any of the columns.