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?!
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?
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