Current position:  Home > Default > No.of Variables in OBIEE

No.of Variables in OBIEE

Time:November 30
Advertisement
Hi,
is there any limit to create number of variables in OBIEE.
Thanks in Advance
Santhosh
Advertisement
hi Santhosh,
There is no limitation

Presentation Variable in obiee 11g

2015-10-11

Hi all , I had a dashboard report with year , quarter , month and order type name as prompts . Now my client requirement is , when order type name is "Ord" , the reports with order type name starting with 'ORD" should be displayed. In simpl

Alternative for session variable in OBIEE Translation

-0001-11-30

Hi all, I am working on translating OBIEE reports to various languages. I am using specific xmls for particular language which has entries for translated text. Now in few of the reports I have case statements/BINs defined in column formula. This 'col

Constraints for presentation variable in obiee 10g

-0001-11-30

Hello Guys, What are the constraints for presentation variable in obiee 10g? requirement: I am unable to find the variable option, when i selects CONTAINS operatior, during creating the prompt.Hi, In 10g, a dashboard prompt can only set presentation

What is purpose of session variables in obiee

-0001-11-30

what is purpose of session variables in obiee and how to use it in obieewhenever a user logs in, a session variable is initialized for that particular user. The session variable can hold values such as Username, loglevel. For example, if you have 10

Date Variable in Obiee 11g

2015-10-11

Hi All, I have created a dynamic repository variable that gives the current date. The date is given in the following format 'MM/DD/YYYY'. This is format that I want the date to appear in. In the presentation catalog, I have created a presentation var

How to pass the values to stored proc using presentation variable in OBIEE

2015-10-11

Need your help regarding in resolving an issue in OBIEE 10.1.3.4.1 There are 6 reports say 'A','B','C','D','E','F' in the same subject area. The reports are being configured with prompts using either the repository/presentation variables. One of the

Bind variable in OBIEE 11G

2015-10-11

Hi, Is there any bind variable concept in OBIEE 11g. If it is not there then how to achieve this.How to write a where clause to get the result set dynamically. Thanks-Bhaskar Gouda Edited by: 961171 on Sep 25, 2012 12:44 AMHi, I can make use of repos

Data and Dashboard Security using ROLES Variable in OBIEE 11g

2015-10-11

Hi all, I'm currently using OBIEE 11g. I'm wondering how to implement the security for data and dashboard in the 11g. Below is the sample of how the security matrix requirement when I use the 10g version. In 10g, we usually use GROUP (for the data fi

How to create Presentation Variable in OBIEE 11g

2015-10-11

Hi, Can any one tell me how to create a Presentation Variable. I know about the creation of Session and Reporsitory variables. Is it to be created in the Edit formula of the column in criteria tab. ThanksHi, Refer : http://gerardnico.com/wiki/dat/obi

How to pass the prompt value to repository variable in obiee 11.1.1.7

2015-10-11

Hi All, I am given a tabular report to build in OBIEE 11.1.1.7 version using insurance data. I have to show different types of claim names and their corresponding count in the table. One of the calculations require me to use the total no of claims(i.

Use of variables in obiee

2015-10-11

Hello!!! I m new to the forum and wanna your help,next week i have to give a presentation on variables , i know how to create them and about their scope but wanna implement its use.(use of all types of variables ie,(repo sitory(static and dynamic),se

Using calculation variables in OBIEE analysis

-0001-11-30

Hi, I have a report where I have to calculate various ratios, including forecast calculations.  If I write a pseudocode for this, it will involve several variables (intermediate step values). In BO, we have concept of variables in Webi to store inter

Accessing Row-Wise Initialization variable in OBIEE Answers 11g

-0001-11-30

Hi All, I need to access row-wise initialized session variable in answers fx section, i came to know from following blog http://carpediemconsulting.wordpress.com/ that i can use VALUELISTOF(NQ_SESSION.ROW-WISE-VAR)) function to get the list of values

Issue with repository variable in OBIEE 11g

2015-10-11

Hi While i am using repository variable directly in filter it is working fine, but when i am using 'repository variable -1' in filter then it is throughing error as 'repository variable -1' is not present. Can't we use - , + on repository varaibles i

Variable in obiee

2015-10-11

Hi, Pls explain how many character stored into the variable. when we are creating variable in admin tool. Example: variable name - Address so i want to know about no of character size.It might be 256 or so. Never tried to test the tool, just used it

Question on Variables in OBIEE

2015-10-11

Hi, I am prasanna.I have a question on variables. Is it necessary to create a different connection pool for session variables? I am unable to use the same connection pool for both repository and session variables. can anyone help me. Regards, prasann

Use of a Session Variable in another session variable in OBIEE

-0001-11-30

Hi, I want to use a session variable say A to calculate value of another session variable B. I am using valueof(NQ_SESSION.A) in the initialization block of variable B. But the result is coming blank. I know that the value exists. I have also set the

Substring function for presentation variables in obiee

-0001-11-30

I have a presentation variable called period that has the (fromdate and to date) Is there any way that I can split this one variable into 2 by using substring function??in such a way that it gives one for from date and the other for to date.. any syn

Populating WEBGROUPS (or GROUPS) session variable in OBIEE 10g

-0001-11-30

We have a user who wants to verify that group-based permissions to various reports he's creating work as expected. Initially, he wanted a user account per group, but as we try to enforce LDAP-based authentication, we have a policy against so many "ge