I have created Query subject using schema dev as
Select * from dev.dm_product
Now there is another schema cognos
A role READ (select) is created on dev and assigned to Cognos.
Cognos has only read privilege from dev schema and there is no tables created in it.
If I write ‘Select * from dm_product ‘ in Oracle for Cognos, then it returns the same result as in dev although there is no physical table created in it.
Now I have to change the schema name for Query subject definition in FWM, I have tried ‘select * from cognos.dm_product’ but it throws an error the table does not exists.
Please give ur valuable suggestions
Regards,
raamzs
You say that the schema 'cognos' has not been created. Why then does it surprise you that ‘select * from cognos.dm_product’ throws an error?
The schema Cognos is created but tables are not created in it.
A role named "READ" having privilage Select ON ANY TABLE OF dev has been created and assinged to schema cognos.
In oracle when i loging as user cognos and write query
select * from dm_product(which exists in dev)
it returns proper result, altough there is no table dm_product created in cognos.
same thing i want to use in framework manager to build a query subject.
Hope i am clear
Regards,
raamzs
Remember that there are no schema names in FM. FM accesses Oracle via a datasource. So to have FM log into a different schema, then you have to use a different datasource which is set up to access the new schema.
So you need to do this:
Create a datasource in Cognos which connects to the "cognos" schema in Oracle.
Use the metadata import wizard and select the new datasource - the tree view comes up which displays all the schema names. Open up the "dev" node and the "table" node, and you should see the dm_product table. Select it and complete your import.
Thanks all for help
I was able do acheive it following ways......
In Cognos Connection home page
Cognos Adminstration > Configuration > More under Actions > View Connection > More under Actions > View Signon > More > Set Properties > Signon Tab > Below Signon ......Edit the signon > Provide the new (cognos here)user id n pwd of user(schema)
Regards,
raamzs