Accessing Perspective report from Other server

[SBK88]

Hi Guyz need your help/guidance .....

I have a SERVER 1 and SERVER 2 in my PRODUCTION environment......
I want to access/run a report from SERVER 1 (perspective report) which is using data from (say)cube 2 residing in SERVER 2.

Need ur guidance for the same.

--
Thanks

[tomok]

Hi Guyz need your help/guidance .....

I have a SERVER 1 and SERVER 2 in my PRODUCTION environment......
I want to access/run a report from SERVER 1 (perspective report) which is using data from (say)cube 2 residing in SERVER 2.

Need ur guidance for the same.

--
Thanks

If by "report" you mean an Excel workbook with DBR of DBRW formulas then simply point the server:cube parameter reference to wherever the cube is located. If you are talking about a cube view then this is not possible since by definition a cube view as a view of one single cube.

[SBK88]

Suppose we have a servers named - AUSTRALIA (only Aus users can access its objects) and JAPAN (only Japan users can access its objects)
Now my question was, Can I create a perspective report in AUSTRALIA server fetching data from JAPAN cubes using DBR/DBRW functions (say sales cube)

I mean how Australia user can get data from other country sever (if i just put JAPAN:SALES)

Is this possible ?

[tomok]

It doesn't matter what your servers are called because you simply provide the name as part of the parameters in the DBR/DBRW formula. However, if the user running the report is not logged in to the server being referenced in the DBRW formula and they don't have at least READ access to the appropriate cubes and dimension elements then the formula will return nothing.