How to Enable SSO for Child and Parent Dashboard / Report

Hii Folks,

This Document will help us to understand the process to Enable SSO ( Single Sign on)  when we use Parent Child approach in Xcelsius / Dashboard Design and avoid users from being Prompted for credentials .

Step 1 : Open your Parent Dashboard in Dashboard Design and go to Data Connection and add ” Flash Variables ” Connection and name it as  “Username ” .

Step 2 : Add Range by clicking on ” + ” Sign and name it as “CELogonToken” and bind the range to excel cell say ” Sheet1!$A$1″ in our case .

Step 3 : Now get the Document Links for Child Dashboard

BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AbTsJdsFoRtDvHCihxGWwNU&sRefresh=Y

Step 4 : Now Concatenate Above link with with Variable ” CELogonToken ” in ” Sheet1!$A$1″ .

=CONCATENATE(“/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AbTsJdsFoRtDvHCihxGWwNU&sRefresh=Y&token=”,$A$1)

Step 5 : Save the Dashboard and here we will Achieve SSO Between Parent and Child Dashboard .

Regards

Jeetan Jagtap