FDMEE REPORTING
Hi Experts, I'm trying to build a new report in FDMEE wih the data which lies in a different schema in the FDMEE DB. I tried using the DBLINK and also mentioning the schema_name.table but it says invalid query. But when i try to build some report from the FDMEE DB schema it works and the validation of query is successful. Can you guys please help me out here, how can i write the query to access the data from another schema.