We have installed new test commerce sites; locally on the ANSRV (analysis)
server, and on the production server. We unpacked a few resources
including
Data warehouse on both servers.
During the process of unpacked we linked Datawarehouse to sql server on
ANSRV (analysis) server, both databases are created successfully in SQL
server.
Even that both databases are added, only local db could be seen in
analysis
view (analysis manager) of the server. The Local datawarehouse has full
structure of commerce datawarehouse in analysis manager including
predefined
cubes.
In analysis manager, database and fully structured view of the site
created
on different server (the production server) was not created automatically.
We
tried to create it manually connecting to databases on SQL server. We are
able to connect to databases created from the production server but unable
to
see predefined commerce cubes.
