Need help in Dashboard?

We have created Dashboard using Live Office in Xcelsius 2008. In Dashboard we have drop down option we can select Client’s Name. We have Row Level Security in Universe As well for every client. When we logged in through the one of the Client ID .Instead of Getting only particular client’s name. we are getting all other client’s name .Every client can see each other data.We want to Restrict that each client can have their name only so that they can choose their Name.

Note:-What we need to do in Live office or Excel sheet???.We want each client can have their option only.

Can you Please Let me know the Solution As Soon As Possible.

Thanks and Regards
Pooja :hb: :hb: :hb:


ktm :us: (BOB member since 2008-11-12)

Hi Pooja,

You are using a webi document to get your data into the excel, right ?

Have you set up folder level security for the webi document where each user is allowed to see only his/her own instance of the report(s) in question ?

How have you setup your live office connection setting ?
I do not remember all the options at the moment.

But within live office (from within the excel file) there is a setting where you mention something like.

  1. Go to latest instance
  2. Go to latest instance of the user who has logged in

you need to make sure that it goes to the latest instance of the report for the user in question.
It also invlolves setting up folder level security so that user can see only his/her own instances.

Going one level higher might help here - ie, first ensure that the data level security is taken care of by referring to webi report/instances.
Once that is taken care of then look into xcelsius.

Hope that helps !

Thanks,


Naresh Ganatra :us: (BOB member since 2004-04-09)

Thanks for your Reply.We are using Universe to get the data in the Exceland use Live office to drag and Drop the Objects from the universe.
Can you please tell me what i need to do in Live Office?
Thanks
Pooja


ktm :us: (BOB member since 2008-11-12)

You can setup the Refresh Setting in LiveOffice to On Demand. (“On Demand : From the Database”.)
You can reach this setting from Excel by going to
LiveOffice >> Properties For All Objects >> Refresh tab

Before going to Xcelsius, have you checked if your row level security is working fine by testing a webi report or so ?

Thanks,


Naresh Ganatra :us: (BOB member since 2004-04-09)

Naresh,
Thank You for your Response. LiveOffice >> Properties For All Objects >> Refresh tab. YOu mean to make Check on
Conceal Data on saving:Refresh data to redisplay.

Thanks
Pooja
:slight_smile:


ktm :us: (BOB member since 2008-11-12)

Hi Pooja,

You get the option that I mentioned only when you are using content from an existing webi document.

In your case since you are inserting new query directly without using an existing webi document that is the option you would see. (Conceal Data on saving:Refresh data to redisplay. ) But concealing makes dashboard development difficult (just my personal observation, there might be work arounds for this)
You might also want to take a look at
LiceOffice >> options >> General tab “Refresh Liveoffice object on document open” and also at the Enterprise tab and set it to Windows AD if you are using that method.

I usually prefer using content from Existing web intelligence document as that gives me better options for refresh settings.

Thanks,


Naresh Ganatra :us: (BOB member since 2004-04-09)

Hi Naresh,
LIveOffice >> options >> General tab “Refresh Liveoffice object on document open”

I found three option there.

1)Prompt before overwritting live office cells
2)Refresh live office object when binding cell changes
3)Refresh live office object on document open

1 and 2 are already checked mark and i did the third one too.
Am i right?

Thanks
Pooja


ktm :us: (BOB member since 2008-11-12)

yes pls.


Naresh Ganatra :us: (BOB member since 2004-04-09)

I would also test row restriction set by creating a QaaWS with the exact same universe objects as the webi document. You can then implement the CELogonToken flash variable on the xcelsius model to pass on the InfiView user information to the xcelcius dashboard which will then return the data for the particular user based on the row restriction set. I am assuming that your restriction set is designed using @Variable(“BOUSER”) technique.


Farhan Jaffery :us: (BOB member since 2005-08-27)

Can You Please tell me how to
Implement the CELogonToken flash variable on the xcelsius model to pass on the InfiView user information to the xcelcius dashboard which will then return the data for the particular user based on the row restriction set.?
Thanks
Pooja


ktm :us: (BOB member since 2008-11-12)

Sedtting up the CELogonToken flash variable is pretty straight forward. See the attached screenshot. Just point it to an empty cell on your Excel model. Once a dashboard containing the CELogonToken is deployed to BusinessObject Enterprise repository, it will inherit login credentials from InfoView and then pass it to the underlying query. If you have a row level restriction set on the @Variable(“BOUSER”) in the universe and you are using a query designed against this universe on your dashboard, it will apply the restriction set.
CELogonToken.JPG


Farhan Jaffery :us: (BOB member since 2005-08-27)

I could not see cotoken login in my live office connections.Can you be more Specific about this.How to make dashBoard Refesh to open?
Thanks
Pooja


ktm :us: (BOB member since 2008-11-12)

As I mentioned in my earlier email, I have not worked with Live Office based Xcelsius dashboards. I think what you were trying to confirm here is first the fact that the underlying WebI document is executing for the logged in user and applying row restriction set. My recommendation is based on a query as a web service connection to a universe. You can create a QaaWS similar to what your live office document’s webi report is and test.


Farhan Jaffery :us: (BOB member since 2005-08-27)

Hi Pooja,

Did the setting LIveOffice >> options >> General tab “Refresh Liveoffice object on document open” not help in getting the dashboard refresh on open ?

Also, did you check the Enterprise tab to see if you need to change anything there ?

Do you have rights to create a webi document and if yes have you checked if the row level security that you have is working as expected ?

Thanks,


Naresh Ganatra :us: (BOB member since 2004-04-09)

Hello Naresh,

Thanks for your Response. when i open the Excel and connect with the live office the object is Refreshing(Fetching Data from the Server).and takes Time. But when i Export it in Infoview .Still we can see all the Client’s LOV.

1)what do i need to change in Enterprise? and i found that at Crystal Xcelsius there is data manager---->live office connection.

when i import the Xlf file in Xcelsius DO i get the Connetions or i have to give the name in the Defination? and set the Range and at the usage Tab check the option refresh to load?we want dashbaord refresh to open? so that client will see their own LOV based on the Row level setup.
Thanks
Pooja
:frowning: :frowning:


ktm :us: (BOB member since 2008-11-12)

Hi Pooja,

I am going to add a summary for you which might be of help. Let me know if you have issues or if you think I might have missed something here.

This is for setting up a dashboard using an existing web intelligence document.

In Excel

Insert the required data into excel using Live office.

Liveoffice >> Insert web intelligence content
select the web intelligence document/tab/table required.

Leave liveoffice options as default
Example (earlier in the thread we were discussing about changing these)

  1. (General tab) Leave “Refresh Liveoffice object on document open” as un-checked
  2. (Enterprise tab) “Use specified logon criteria” unchecked

Liveoffice >> Refresh options
3. Latest instance: From the latest instance scheduled by (from the drop down) Any User

In Xcelsius

Goto
Data >> connections (this will take you to the Data Manager)
and Add “Live office connections”
specify the server name in the url
http://servername:8080/dswsbobje/services/session

In the usage tab of the liveoffice component, Check the “Refresh on load” checkbox

Publish your dashboard.

For the particular folder in which your webintelligence document is located,
the folder security should be set in such a way that every user is able to see only his/her own instances.
“view document instances” is Denied
“view document instances that the user owns” is Granted

Before publishing the swf file the BOE you could even check by generating a swf locally on your machine and logging in as seperate users.

Regards,


Naresh Ganatra :us: (BOB member since 2004-04-09)