Scenario: We have a SSIS Package which processes the 2 Cubes.
When we try to Process the Cube/Dimension Manually.. it Works.. But the
Pain Started when we try to do the same thing Through a SSIS Package.

SSIS Package uses some variables and aggregation dumped into a Tmp
table off which the DImensions are Based..
Some of the Dimensions are created from Views(Which return data from
Linked Server).

Typical Error we get is here.: I am a SA on all of these Boxes, but
that doesnt help.
OH Yes another Scenario: This same Layout Works in the TEST
Environment.
TEST LAYOUT: DBSVR1-->SSASSVR1-->Works BUT DBSVR2-->SSASSVR2--> Doesnt
Work.

I know you have a Quick Answer on the TOP of you Head, but Think about
this, we tried everything for the past 3 days and nothing seems to Help
us. If you are thinking something we already tried it. We tried
Combination of Priviliges across Servers/Dropped and recreated Linked
Servers/Restores TEST Cubes and Databases into PRODUCTION Environment
as it is/ Worked with Windows as well as SQL Authentication/ Tried
changing Object Ownerships etc... We have finally decided to Open a
Call with MSFT. Before Going ahead with the CALL I wanted to give a
LAST SHOT here, if anybody came across this ERROR and has RESOLVED it,
Pl show me the Light.
The Table names and Servers Names are TRUE as Projected in the ERROR.
Here is the Error.
/*
Errors in the metadata manager. Either the dimension with the ID of
'Heat Slab Slip' does not exist in the database with the ID of
'DataGrub, or the user does not have permissions to access the object.
*/

Thanks in advance for your Help

What is the user associated with the SSIS package?


"Maninder" <msdhanjal (AT) gmail (DOT) com> wrote