Cognos session parameters usage
I have setup LDAP authentication and set up "custom properties" in cognos configuration to get a attribute i have defined in the LDAP entry.
For example this custom property is called ORG_NAME, how do i use this ORG_NAME in report studio as a parameter to filter on? I have seen online about mapping with Framework manager.. however the particular reports i am using access the database directly and DO NOT have a framework manager package associated with them, so i need to use the ORG_NAME without using FM....
You can use the same syntax you would use in FM. So, for example:
#sq($account.personalInfo.givenName)#
will return the first name, and so on.
If you feel some burning need to for user-written SQL, instead of using FM, you can include the macro as a query item in your "outer" query (that gets the results from your sql query, Query2 in the image below).
- How I can set a session in codeigniter 3 database?
- How to print all session variables currently set?
- why most of the website cannot work without cookies?
- Paging doesn't work in the Joomla Article Manager in the admin section
- How to use session_start in Wordpress?
- ExtJS: store, pagingToolbar and PHP session expire
- How to use telethon session file to login with pyrogram
- What should we store in the session when using session-based authentication?
- OpenLiberty Database Session Replication - org.jboss.weld.module.web.HttpSessionBean$SerializableProxy - ClassNotFoundException
- Reopening a session in PHP
- SFTP connectivity via Jsch fails with "Auth fail for methods 'publickey'"
- Artisan command for clearing all session data in Laravel
- How to write to the Flask Session from a child process
- Batch statements return "Unconfigured table" error
- How to get a session object in the server side in next.js 14?
- How to save the browser sessions in Selenium?
- How to specify where flask should store cookies (flask Session)
- PHP Sessions Not Extending Cookie Expiration on Each Request
- Read Flask Session Cookie
- How do I create a session that runs from friday till sunday the following week?
- Check if PHP session has already started
- Session not persisting after redirect during Google OAuth 2.0 flow
- Why cookies dont expire after closing browser?
- How to display all session keys and values in Django?
- Is there any way to add custom column to sessions table while working with pdo sessions
- Property `user` does not exist on type `Session & Partial<SessionData>`
- How can I keep my user's login session open in my flutter application?
- __PHP_Incomplete_Class_Name wrong
- How I can update session in server side
- Magento: getSingleton('customer/session') doesn't return information when called via SOAP