Getting a variable from an external application

kiran.gs · Nov 16th 2015, 6:54am

We have an internal application that we use. I am using the data from the application, pulling into Jedox and building dashboards and reports. These dashboards and reports are embedded back into the application. It is a good setup, because I can customize the reports and dashboards as required by my management.

I need to do one additional thing here. Depending on the user who logs into the internal application, I would like to hide or show certain filters/ fields/ etc. Is there any way for getting the logged in user as a variable into Jedox?

Thanks
Kiran

laloune · Nov 16th 2015, 9:32pm

Hi Kiran,

the =CURRENTUSER() function should fit your requirements : knowledgebase.jedox.com/knowle…ox-spreadsheet-functions/

or if you use the php api you can use jedox_get_username()

kiran.gs · Nov 17th 2015, 5:32am

Hi Laloune,

I agree that I can use =CURRENTUSER() will work, where I get the login of the user who logs into Jedox.

However, in my scenario, I also need to get the username from the external system (in which Jedox report is embedded). I have the username as a session variable in the external system. Is there a way I can import the session variable into Jedox?

Kiran

laloune · Nov 17th 2015, 10:22pm

ok got it.

in which language is your external system?

kiran.gs · Nov 19th 2015, 8:57am

It is a php and javascript based system.

laloune · Nov 19th 2015, 1:09pm

ok. I would say that you could setup a webservice in the external app serving the username, that you could call using a macro (SOAP call)

what do you think?

kiran.gs · Nov 23rd 2015, 5:51am

Thanks Laloune,

I was thinking on a similar lines.. if not a SOAP call, a php widget that can get the username from the webservice and paste it into a Jedox variable ..

Have not been able to try it out yet.

Kiran

Getting a variable from an external application

Getting a variable from an external application

Share

Similar Threads