If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cannot see non dbo schema tables in Cube Design

Started by nav_shiv, 04 Dec 2015 10:49:13 AM

Previous topic - Next topic

nav_shiv

Hi

I am just having a practice in Cube Design 10.2.2 by replicating the sample model over the GOSALESDW SQL Server database.

Everything was going well until I created my own table set Current Period so I can add relative time levels.  The table is party of the gosalesdw schema as per all the other tables in this database.  However when I refresh the metadata in Cube Designer the new tables does not display in the list.  I can see all the existing gosalesdw sample tables but not my new one. 

I have tried to bring it through into a new model but I still cannot see it. I have reapplied FP3 which made no difference. 

However I created a table in the dbo schema and I was able to pull this through from the Get Metadata option.  This made me think the problem is with the security in SQL Server with the account being used in Cognos Administration.  I've changed the default schema between dbo and gosalesdw but that makes no difference.  The account obviously has the right privleges as it can see the existing tables.

I have compared the properties of the new gosalesdw and dbo table against existing ones but nothing obvious here.

Is it just me?!

bus_pass_man

If you try to import the metadata in FM can you see, import, and test your table?

Are any messages which might be relevant generated in the xql log file?

nav_shiv

Yes I can see them in FM.

We found a way to fix this although not ideal.  File C:\Program Files (x86)\ibm\cognos\c10\data\relmd_great_outdoors_warehouse_GOSALESDW_gosalesdw.xml  needs to be renamed so that it is ignored by Cube Designer.  I just change the extension to .bak.

When I open the model and refresh the metadata I saw the new table.

Hope this helps others.

Thanks