Using Jet Data Manager 4.5.34.64 I am encountering table not found errors when I try to deploy a new cube or dimension.
>>
Table 'Sales_Service_V' was not found in the data source view.
The most likely cause is that deployment is needed on the data warehouse.
<<
I'm trying to add new SQL Server data to an existing OLAP Server, JetNavOlap. This is data present on the SQL Server that I've been able to successfully deploy and execute to/from JetNavStage–> JetNavDwh, and was able to deploy to a cube in an entirely new Olap server in the same project.
However I wish to have this sales information cube in the existing JetNavOlap server. When I try to deploy the same cube or dimension (bottom part of the screen), both parts fail with the above error:
I've deployed repeatedly from the data side, can see the data in the staging and warehouse, and even removed all of the staging data and added it back in with a different name. A 2nd cube also fails. Both worked in the standalone cube on the same server. Everything has been done using a Jet admin login, via a remote desktop connection.
The table Sales_Service_V is physically present in the JetNavDwh database.
Date
Votes
1 comment
-
Jet Reports Historic Posts I was able to resolve this by doing a deploy and execute of the entire Data Warehouse, followed by a deploy and execute of the entire OLAP Server. After doing this the cube level deployments are also working, so I assume the metadata was incomplete at some point.
Please sign in to leave a comment.