If you want to know current assigned values of server variables with in your BI Server then follow these steps.
1. Open RPD
2. Goto Manage menu tab
3. From manage menu select “Sessions …”
 |
| From O.B.I.E.E |
4. Pops up Session Manager
5. From available sessions choose a session
6. Now click on variables tab, it will show all server and session variables and respective values at that particular time.
 |
| From O.B.I.E.E |
In general following type of variables you can see here
Session System: all these variables have specific purpose (reserved key words) with in BI system
Exp: USER, DISPLAYNAME, EMAIL, LOGLEVEL, GROUP, LAST_SYNCH_TIME, PORTALPATH, REQUESTKEY, SKIN, WEBGROUPS, PASSWORD
Session Non-System: These variables are created by admin, for various reporting purposes.
Exp: USERROLE, USERGEO, USERCURRENCY etc
Session System and Session Non-System variables are specific to user logged on.
Dynamic Repository Variables:
These variables can be used by any users with in BI system created by admin,
Exp: LASTWEEK, LASTMONTH, YESTARDAY, CURRENTYEAR etc
Static Repository Variables:
These are initialized when BI Server start remain same as long as server runs.
Exp: PATH_TO_RESOURCE_FILES, WELCOME_MESSAGE, etc.
For more information on variables and how to create variables look at here
Best practice: Optimally define dynamic repository variables.
Did my way of intialization(snap shot) is recommended way ?
ReplyDeleteI think not a good practice because we can move dynamic variables(Current year, Last week etc) to session variables, instead of dynamic repository variables what you guys say ?
Since not all of my developers have Admin Priveleges and can't get into the RPD AND I have some savvy Answers Users who like the variables, I build a dashboard with a page that references them (yes I have to keep it updated):
ReplyDeleteExample:
CURRENT_WK_DTE = TIMESTAMP '2009-08-29 00:00:00'
CURRENT_WK_DTE_JULN = 2455073
CURRENT_WK_DTE_STR = 08/29/2009
I use @{biServer.variables['VARIABLENAME']} in a Narrative and list out all the variables currently avalable for use and what thier current value is.
@Thomas
ReplyDeleteThat's an excellent idea...
You can also use
ReplyDeleteCALL NQSGetSessionValues('NQ_SESSION.USER,NQ_SESSION.GROUP)
from Issue SQL Directly etc to get at some of the values.
@rnm,
ReplyDeleteThanks, one new thing to me.
--Srinivas
To rnm1978
ReplyDeletesounds like an excellent idea only i cannot get this to work
copying this into a Issue SQL Directly request
CALL NQSGetSessionValues('NQ_SESSION.USER,NQ_SESSION.GROUP)
NQSGetSessionValues only this blog came up)
I get the following error:(itried searching
error : Odbc driver returned an error (SQLExecDirectW).
error : State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 17001] Oracle Error code: 1756, message: ORA-01756: quoted string not properly terminated at OCI call OCIStmtPrepare. [nQSError: 17010] SQL statement preparation failed. (HY000)
error : SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL sourceoltp CALL NQSGetSessionValues(''NQ_SESSION.USER,NQ_SESSION.GROUP)')}