how to Changing theOBIEE11g homepage for all users/group wise?

Hi,

Changing the homepage for all users

https://forums.oracle.com/forums/thread.jspa?threadID=2315792&tstart=0


1. Created a session init block
2. Used data source as select '/shared/SH Test/_portal/Test1' from dual
3. Assigned this value to PORTALPATH session variable
4. In Presentation services > Administration > My account > Default dashboard should be set to 'default'. Then only the dashboard specified in init block will be displayed otherwise My account will override the init block.



5. Save the changes made to rpd.
5. Logout and relogin to see if it is working fine. it is working perfectly fine.
if you like to have user/group based home page.
1. They may need to have 2 separate tables.
i. Group_path_tab with 2 columns. Group_id, portal_path
Have group wise portal path for all the groups
ii. User-group map table
Group_id, Group_name, user_id
User should be part of some group.
2. Then in the init block write the sql should be something like this
select A.portal_path from Group_path_tab A, User_group_map B
where B.user_id = :USER
and B.Group_id = A.Group_id
E.x:
Creat new init blok like below one
GPC_Home
select '/shared/AFS/_portal/GPC AFS Reporting' from dual
see my screen short:
http://imageshare.web.id/images/z5gz8tithwypn4vfgm14.jpg
here set u r home page url path like below one
'/shared/AFS/_portal/GPC AFS Reporting'
create anothe init blok
USER_LOGIN
select User_ID from User_Group_Map where User_ID=':USER'

So based on USER session variable, it will try to identify the group and then the portal_path.
Finally assign this value to PORTALPATH session variable.
for more  refer below SR:
http://varanasisaichand.blogspot.com/2011/03/system-session-variabels-obiee-11g.html
http://varanasisaichand.blogspot.com/2011/03/system-session-variabels-obiee-11g.html
SR 3-3432126511: ^how to Changing theOBIEE11g homepage for all users/group wise?


FYI,I have followed given below link.

http://total-bi.com/2011/01/obiee-11g-change-default-dashboard/



Regards,
Deva

LDAP Configuration in obiee11g

for more clear steps in this context.
http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10543/sso.htm#CEGJJFED

http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10543/toc.htm.

SSO can be implemented in OBIEE 11g by steps like

1. Configure the SSO authentication provider.
2. Configure HTTP proxy.
etc

How to create session variables for UserID in obiee?

http://forums.oracle.com/forums/thread.jspa?messageID=3447246&#3447246
http://forums.oracle.com/forums/thread.jspa?messageID=3376727&#3376727
http://gerardnico.com/wiki/dat/obiee/saw_url_session_variable

fetching dashboards login userid
session variable:
--------
DISPLAYNAME
init block:
---------
datasource type is OBIEE server
SELECT username,groupname from usera where username=':USER'

Unable to Sign In into presentation services and RPD obiee 11

Issue :I had a  trouble to login into RPD (online mode) the Presentation services lately.
It was working fine before and after changed console user sequrity things changed and was having issues to login lately after that.
It always gives me invalid username/Password was entered message when I tried to login no matter what ever username I tried.
I was able to login into Enterprise manger and Weblogic Admin console successfully with out any issues. All the processes are up and running with out any issues.
Tried rebooting successfully and still it wont let me login into Answers. So I tried if i could login into Admin tool and it wont let me login there as well.
So I created new Admin user in the Weblogin console and tried to login using the new user and still no luck. The new admin will let me login into the EM and WLC but not into Answers and rpd.
I tried deleting old references of the user directories in the catalog and still no luck.
It has something to do with the credential store. What ever user name I created its not mapping it to the Answers/rpd inspite of both the services are running
 Solution:
======

1. Please follow instructions given in
How to fix “Unable to Sign in. An error occured during Authentication" error when a user logs in OBIEE 11g (Doc ID 1302924.1) step by step, for those steps you have done, please double check and make sure what you've done are correct.

2. You are still not able to logon because you have missed a few steps as the following:
8. Edit the NQSConfig.INI file to reset the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES to NO and restart the Oracle BI Servers.
9. Remove, set to none, or comment out the line (see UpgradeAndExit in the following example) added to the instanceconfig.xml file (that instructs Oracle BI Presentation Server to refresh GUIDs on restart).
10. <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
11. <ps:UpgradeAndExit>false</ps:UpgradeAndExit>
12. <ps:UpdateAccountGUIDs>none</ps:UpdateAccountGUIDs>
13. Restart the Presentation Server for the instanceconfig.xml file that was updated.
14. Make sure Oracle WebLogic Server and the system components are also running, if they are not running, restart them.

b) Relogin as the problematic user to verify if you still see the “Unable to Sign In” error

Step 2 : Delete user from rpd if present

a)Launch admin tool and open rpd in OFFLINE Mode
b)Click Manage > Identity > Users tab to verify if you see this user present
Note : Normally you will only see list of users when you open rpd in ONLINE mode. Unless the users were created manually in rpd, no users should be visible in OFFLINE mode
c)If the user is present, delete this user entry from rpd
d)save rpd and deploy this changed rpd using EM
e)restart OBI Server component
f)relogin as the problematic user to see if you still see “Unable to Sign In” error

Step 3 : Delete the cacheduserinfo file from webcatalog
If Step1 and Step2 does not work, then do the following
Note : In the example below, catalog name is SampleApp and the user who gets “invalid Login” error is Administrator user.


a)Take a backup of your webcatalog
b)Navigate to C:\OBIEE11G\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleApp\root\users\Administrator\_prefs
c)Delete the files name cacheduserinfo and cacheduserinfo.atr
d)Launch OBIEE 11.1.1.3 and test by logging in as the specific user.

the best one is 3rd one.