Page 1 of 1
Accessing Perspective report from Other server
Posted: Tue Dec 27, 2016 7:45 am
by 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
Re: Accessing Perspective report from Other server
Posted: Tue Dec 27, 2016 3:30 pm
by tomok
SBK88 wrote: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.
Re: Accessing Perspective report from Other server
Posted: Sun Jan 08, 2017 2:12 pm
by 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 ?
Re: Accessing Perspective report from Other server
Posted: Sun Jan 08, 2017 5:04 pm
by 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.