Ask Me

G Kishore

August 25, 2008 at 11:39 am

Hi, Shiva… Glad to meet you..

Reply

keerthi

June 13, 2011 at 3:46 pm

hi can u plz explain use of allias tables in physical layer

Reply
- madasameee
  
  July 16, 2011 at 11:28 am
  
  Hi Keerhi,
  The alias table in physical layer aiming mainly at Multiple drill down for a single table. Say a day table “W_DAY_D” has many columns ( Day, Month, Week, Year, fiscal Year ). To drill down everything as per requirement, we create multiple alias table and use different PRIMARY keys and drilling the same table. This is the main use of having Physical Layer.
- keerthi
  
  November 25, 2011 at 8:01 am
  
  why should we avoid circular joins in physical layer
- Siva Reddy
  
  February 23, 2012 at 10:43 am
  
  Hai Keerthi,
  
  Because of improving the performance that y we don’t use the circular joins in physical layer.and obiee does’t supports self join in this situation we are creating the alias tables it is the best practice technique.
- sekahr reddy
  
  May 22, 2012 at 5:24 am
  
  alias tables are derived from physical tables to meet the particular requirements.
  alias tables are used to join to the tables multiple times with different conditions
  alias tables are provide different information for the different join conditions.
  
  if u want to use the table more than once in query then we can create the alias tables for that tables
  
  usually obiee does not support self join functionality to implement this functionality we will create alias tables in the obiee
- Praveen Chandra
  
  May 31, 2017 at 3:53 pm
  
  Hi shiva & All,
  We mainly use for re usability of the table
Ramana

November 6, 2011 at 5:09 am

HI Shiva,

We are going to develop reports on R12 Error Tables which are in Oracle Apps. In some Tables they don’t have Primary key column and also don’t have any numeric values.. How can do report on this. Please suggest me. It is little bit urgent..

Thanks

Reply
jagadish

December 16, 2011 at 11:12 am

Hi Can u plz explain, how to enable grand total button in obiee table view by defaulty.
by default it is in disable i want to enable by default ie how change xml tags

Reply
Raja

May 21, 2012 at 3:46 pm

Hi Shiva,
Hi MK,
My requirement is displayed in bellow columns
Ex:
Date Geo PRV_QTR_BKG PRV_YEAR_QTR_BKG PRV_ENT_QTR_BKG PRV_ENT_YEAR_BKG
05/10/2012 US 30 50 200 300
05/11/2012 IND 35 40 200 300
Conclusion:
PRV_QTR_BKG should be calculate on user parameter date like 05/10/2012 means 2012 Q1 in 40 days sum of bookings with combination of dimension columns like geo, product, channel. Same as PRV_year_QTR_BKG
PRV_ENT_QTR_BKG should be calculate on same parameter but sum(90) days bookings with combination of dimension columns like geo, product, channel. Same as PRV_YEAR_ENT_QTR_BKG
Thanks,
Raja

Reply
Lateralus

June 5, 2013 at 10:02 pm

Hello!

I write from Spain.

What’s happen with Delivers in OBIEE 11.1.1.7? I think is not there. Have i to install OBIEE Apps to schedule reports?

My mail is: mesevalapinza@yahoo.es

kind regards!

Reply
Avnish Kumar Singh

October 19, 2013 at 4:00 pm

hello sir,
Please can any one help me how to uplpoad your database on server side my web space on shiva.cms500.com i have didn’t get any option to upload our database on server side

Reply
kiran

January 6, 2014 at 1:19 pm

Hi Shiva,

I have some table in a db where I need to present it for reporting. Lets say tables are presented in performance schema .so we query these table like select * from performance.table_name ….

In obiee one developer mentioned all physical tables names as performance.table_name in physical layer of rpd to make obiee server query these table which is present in back end db.

So I want to decrease development effort .I have some 25 – 30 table for reporting . Could you suggest necessary changes to be done to decrease development effort.

Regards,
Satya Kiran.

Reply
ravi

April 18, 2014 at 3:15 pm

Hi shiva,

i need sorting on month_year(Ex:mar-13) in obiee report and i need to display latest 12 months data in report please reply asap

Reply
Pavan

June 9, 2014 at 5:47 pm

Hi Kishore, i have a date column, in dash board user want see only last month last day data.(ex: this is june month(1 to 30) user can see only may 31st data in dash board. when user in july he want to see june 30 data dynamic.if last month data is not available its go to previous month data EX:- now we r in july its shows may-31st data, its not available its go to Aprial- 30 if not available March-31st data like dat……. need to show in dash board) in obiee

Reply
- mahendra
  
  July 31, 2015 at 11:42 am
  
  i think u want to pass the dynamic variable in the dash board prompt as the server prompt ….. for that dynamic variable in the initialition block u pass the sql quarry to get the last month data
Pavan

October 14, 2014 at 3:42 pm

Hi shiva,

I have couple of questions regarding on cluster environment.

we have a 4 node cluster environment and node1 and node2 are configured for failover in EM as primary and secondary servers.

Q1.Now my problem is when I bring down primary and secondary servers, I was unable to login to the other 2 instances. Its throwing invalid username/password error.

Q2. I dont see scheduler and cluster component on the other 2 instances.

Q2. I am rebooting the entire BI Application.

Here are the steps I am following to bring the application up. Please let me know if I am doing it the right way. My question is should I start the weblogic on all the instances are just on the primary instance.

1. start weblogic on node1
2. start node manager node1, node2 ,node3 & node4
3. login to EM and start the managed servers bi_server1, bi_server2, biserver_3 & bi_server4t
4. finally start all the components.

Appreciate your help

Thanks,
Pavan.

Reply
Reddy Reddy's

February 1, 2015 at 3:51 am

Can we apply saved filters to union reports in obiee 11g?

I am able to apply saved filters for normal reports but not for union reports.
The catalog pane is blank, when i click on result columns or each criteria.

The only option i see is to manually create the filters for each criteria, dont i have any choice to use a saved filter for union report?

Reply
- Catherine
  
  August 31, 2015 at 1:36 pm
  
  I have found that I can only use saved filters on a union report by adding them in the report before I save the report for the first time. If I save the report, close it and then come back later to add the filters, my catalog pane is also blank. Hope this helps.
- SATYA
  
  November 27, 2015 at 5:34 am
  
  Me to getting similar issue. Please let me the solution of this
praveen

February 13, 2015 at 11:13 am

Hi Shiva and All,

I would like to know ,How to update my time dimension records at present the data availale up to 31-Dec-2015 but i need update till 31-dec-2020 how to proceed for this .

My working application is bi apps , could you please provide the necessary spets to follow.

Tools versions– Oracle 10g ,Dac 10g, informatica 8.6.1

Thanks& Regards,
Praveen

Reply
hayasri

April 25, 2016 at 6:59 pm

I will give one requirement try it
Suppose I have a report d1, f1,f2
With pivot table view
I result I am getting one row as all zeros
I don’t want to display that row how?

Reply
- Shiva Molabanti
  
  October 12, 2016 at 12:29 am
  
  Filter it out on the key column where you dont want to see it.
kedharnath

June 6, 2016 at 5:48 pm

Hi Shiva

I created a measure in rpd with count(number), but results are same for all rows.When I checked in physical query its aking sum(count(number)) .

Reply

Sripriya

September 26, 2008 at 8:55 pm

Hi Shiva,

When I do a cast(’08/01/2008′ as date) it does not work. It expects me to do a cast(’01-AUG-2008′ as date). But how do I convert strings in the mm/dd/yyyy fashion ?

Thanks,

Sripriya.

Reply

madasameee

July 16, 2011 at 11:33 am

yu can use to_date function ( Oracle function can be used and can be converted into date again back)

Reply
toba

January 31, 2012 at 11:21 am

to_date(20120108,’YYYY/MM/DD’)

Reply

Shiva Molabanti

October 2, 2008 at 4:26 am

hi sripriya,
where do you want to do casting in answers? or Repository itself?
If it is in repository no problem you can cast as your db expects like cast(’01-AUG-2008′ as date).because your DB default format is ‘DD-MON-YYYY’.so cast the same but when you are using the converted column in answers it will display in mm/dd/yyyy format only as it is the default format for obiee answers.

Reply

gayathri

March 22, 2014 at 1:48 pm

Hi Shiva i have a reqirement to display the past 1 quarters data for a report in which the quarter is coming from a promt.so the quarter will be changing dynamically every time as user selects.

Reply
Pawan

April 9, 2014 at 3:55 pm

Hi Shiva
I have to design a data quality dashboard. Requirements already have been collected Can you pls. help in arranging FUNCTIONAL SPECIFICATION DOCUMENT FOR OBIEE DASHBOARDS / Reports.
Thanks

Reply
venkat

March 30, 2015 at 4:27 pm

Hi shiva,

I have an issue like we have environment of bi publisher as part of obiee and using oracle fusion middle ware security where we have implemented external LDAP(users maintaining in LDAP) authentication in web logic console and when user login with admin privileges in bi publisher ,permission tab is disabled what will be the problem,how to enable this issue ,is there any procedure ?

help me on this

Thanks

Reply

Adrian ward

October 2, 2008 at 8:09 am

Hi

Nice chart of Variables. Please can you refer to it in my blog (I’ll reference your origal post)

Keep up the good work

Adrian Ward

Reply

Shiva Molabanti

October 3, 2008 at 10:33 am

Hi Adrian Ward,

You can refer my post in your blog.

Shiva

Reply

sankarnaveen

December 23, 2011 at 1:41 pm

hi

am a new developer in obiee
can we build a repository using single physical table

if yes how?
if no why?

Reply

Shyam

October 4, 2008 at 10:26 am

Hi Shiva,

I Have a requirement such that have to display both parent and child values on same report line based on account. The layout will look like as follows,

Accnt Parent_Amt Child_Amt1 Child_Amt2 Child_Amt3
123 150 50 50 50
345 300 125 75 100
678 100 30 30 40

Data Model is as follows:

Parent_id Child_id
1 10
1 20
1 30

Fact Table

Acct_id Parent-Child_id Amt
123 1 150
123 10 50
123 20 50
123 30 50
345 1 300
345 10 125
345 20 75
345 30 100

How can i acieve the above layout in pivot view?

Thanks.

Reply

Raghu

October 15, 2008 at 12:17 am

Shiva

For the presentation services in OBIEE, I noticed that there is a Tree strcuture and also drag&drop functionality. Is this built using C++ or JSF or somethign else? Also where is the data into the Tree on presentation services coming from? Is this metadata stored anywhere in a relational app specific schema?

When we installed OBIEE, did not see any schema, there are soem scripts if we need to use scheduling. I understand some proprietary format is used to store metadata information in OBIEE.
Is there any schema to store any metadata? Also, is there interactiev reporting in the web client or are the reports created/generated in the fat client and published to the web client?

Is there any functionality to create and generate reports from the web client? Also what is the product using for the drag&drop features on the web client?

Reply

Shiva Molabanti

October 15, 2008 at 7:45 am

Raghu

1.The features in OBIEE Presentation services are defined in XML and called via JSF on runtime.
2.To get the Metadata you need to have UDML script
3.To generate any reports you should be coupled with BI server,so normally people will provide presentation service in one machine to be queried by users/to generate reports and to maintain load balance we will have clustering concept

Shiva

Reply

Shiva Molabanti

October 15, 2008 at 8:43 am

shyam,

Let me know how the tables are related
You have given two tables but in any of them tables there is no Primary key.let me know where is the primary key.and you should have the fact table like accnt,parent_id,child_id,Amt

shiva

Reply

Raghu

October 15, 2008 at 1:40 pm

So,

I have seen some style sheets (XSLT) that look liek they are transofrming the data, are these really transforming the XML that you mentioned in presentation services?

Also, Does the web tier (not the fat client) support drag and drop and how is it implemented?

Also, can generate reports on the fly from the web application (browser client) and not just the fat client?

Reply

Yazan

March 5, 2015 at 6:43 am

Raghu,
Did you find any way to generate reports on the fly from the web application (browser client) ??

Regards,
Yazan

Reply

Raghu

October 15, 2008 at 1:43 pm

Shiva

I also read that for the report repository, either a file system or a database can be used.

Is this true for the metadata as well? Is there anything during the install that prompts a user to chose between a file system based or database based metadata repository?

Reply

Shiva Molabanti

October 15, 2008 at 5:04 pm

Raghu,

Yes,That’s true we can use any of them like file systems as well as databse to develop metadata repository.
And there is no option while installing to choose either of these type metadata repository.
You can use any of them or both.
Metadata will get the data from different sources not only from the filesystems or Databases
even from EPMs,

Reply

Pratik

October 30, 2008 at 1:50 pm

Hi,

I have created one non system server variable in RPD. After initializing it does not show any error, but when i used the same variables in select query of Table definition, it gives warning that variable does not have any value definition.

Please note that i am using more than 1 variables in the same query and which even is the last variale, that variable gives warning by “Repository Variable does not have any value definition”

Can you please guide me on this?

Reply

Sripriya

November 10, 2008 at 11:16 pm

Hi Shiva, Thanks for responding to my earlier question.

I now have an issue with Informatica Lookup Transformation.

To figure out the functional head for an employee, I am going up the hierarchy using a person’s supervisor id and a connect by prior clause.

CONNECT BY PRIOR supervisor_id = person_id
START WITH person_id = 1541

In the lookup, I want to use the input port as in
START with person_id = PERSON_ID_IN

It does not seem to like that.

But I have to use it somehow, without which the START WITH will not work.

Could you let me know how to achieve that ?

Thank you so much.

: Sripriya

Reply

Shiva Molabanti

November 17, 2008 at 7:13 am

sripriya,
To achieve this starts with functionality you can use the LIKE operator.
ex:CONNECT BY PRIOR supervisor_id = person_id
AND person_id LIKE ‘1541%’

i think it will solve your issue

-Shiva

Reply

vijayyajurvedi2008

November 24, 2008 at 1:47 pm

Hi

I want to combine multiple go buttons in single go button

please provide me solution.

I tired with sranka’s blog but i lost my prompts functionallity.

please mail me the thing worked done using sample sh rpd and web cat that comes with obiee

mail me to vijay.yajurvedi@gmail.com

Reply

Suresh

November 28, 2008 at 9:02 am

Hi,

How to reference a dashprompt column and use it in a request ?

–Suresh

Reply

Shiva Molabanti

November 28, 2008 at 3:02 pm

Suresh,

Using Presentation variables you can use dashboard prompt values in your Request.

-Shiva

Reply

babu

December 10, 2008 at 12:04 pm

Hi Siva,

When do you think we need to create hierarchy in OBIEE. I see some rpds where lot of dimensions are having hierarchy levels ‘Grand total level’ and a ‘Detail level’ only. In DW terms it is not a hierarchy, but looks like this is kind of standard in OBIEE? Can you please let me know your thoughts on it?

Thanks,
Babu

Reply

babu

December 10, 2008 at 12:55 pm

Hi Siva,
One more question on the same lines. If dimension has 15, do all the fields need to go into Details level? (note: we only have ‘Grand Total level’ and ‘Detail level”.

Thanks,
Babu

Reply

Shiva Molabanti

December 12, 2008 at 5:54 am

Babu,
Actually the concept of hierarchy is meant for two things
1.drill-down
2.level based values
if in our application we are not specific about drill down path then we are creating the only two hierarchies i.e Total level and Detailed level,these will help us to have ‘Group-By’ clause in our BI query.
If your dimension has 15 then no need to have all the 15 fields but you should have the key column(primary key for the concern dimension) in detailed level…

-Shiva

Reply

babu

December 12, 2008 at 10:27 am

Hi Shiva,

Thanks for reply. Let me give my understanding of your response with an example. We have a Supplier dimension (no levels) and we also didn’t create Total/Detail levels in OBIEE. Now Supplier is logically joined to fact Purchase order fact, having a measure purchase amount. Now in OBIEE answers if customer pulls Supplier name and the purchase amount, it will not work (no grouping will be done). Is this what you are saying? If not can you please clarify with an example.

Thanks,
Babu

Reply

babu

December 12, 2008 at 11:09 am

Hi Siva, in earlier example, there is also a physical join between the Supplier dim and purchase order fact.
Thanks,
Babu

Reply

Shiva Molabanti

December 16, 2008 at 6:33 am

Babu,
If you want to drill down the supplier dim attributes like
Region->market->City->Supplier then you need to create the dimensions with these hierarchy.
suppose if you don’t need this specific hierarchy then just create dimension (Right+Click on the Dimension Table) automatically it will create one dimension with two levels i.e 1.Total level and 2.Detailed level where you will find the key.
now if there is any direct physical join between this dim to any fact then in the content tab make the fact LTS to this Dim-Detailed level otherwise keep it at total level
then the BI query will generate the Group by even though theer is no join..

-Shiva

Reply

Kumar

June 26, 2014 at 9:55 pm

Hi,

Can you please share me your contact details

Due to some issues I cant discuss my requirement over here.

Request you to drop me your phone number

Regards
Kumar

Reply

Venkat

January 2, 2009 at 11:02 pm

Hi Kishore,
Can you let me know in detail about Alias tables. why & where do we use them? If possible with an example.

Reply

Shiva Molabanti

January 6, 2009 at 7:33 am

Venkat,
We can use alias tables in many situations
few of them are:
1.To have Degendim in BMM layers
2.To design star schema when we have Fact-Fact relations..
etc…

Reply

Venkat

January 6, 2009 at 5:15 pm

Thanks for the reply Shiva.
Can my alias table’s columns be from multiple tables?

Thanks,

Reply

Sum

January 10, 2009 at 1:11 am

Hi Shiva,

I need some help in building the following type of report.

the report i am building has date (in form of FY YR MMMM .. basically like FY 04 March), the price, the sales and %.

What i am trying to achieve in this report is when the user logs in.. say jan 09.. the report should display values for the last 12 months.. basically from dec 09 to dec 08 and every date/month before that in Others.

This should change dynamically .. like ifthe user logs in march 09.. report should so data from feb 09 to feb 08 and every month month before feb 08 goes into others with an updates total price and sales amount.

Can you help me achieve this.

Thanks

Reply

Shiva Molabanti

January 13, 2009 at 5:28 am

Venkat,
The aliasing would for one table not for multiple tables,
so you can’t use the alias in physical layer from multiple physical tables

-Shiva

Reply

Shiva Molabanti

January 13, 2009 at 5:31 am

Sum,
I have published one article which will illustrates the same functionality of how you are expecting,you can check at this URL:

Last N months(Rolling months) data By year-month prompt in OBIEE

-Shiva

Reply

Santhosh

January 15, 2009 at 4:49 pm

Hi Shiva,
I have a report which show Sales Analysis figures for week to Date. I have to show pie chart for each of the day pertaining to that week. Am using Chart Pivot Data Option in Pivot view for getting separate pie chart for each report.

I have placed the date column in the Sections of the Pivot View. Am getting sepate charts for each of the day in that paraticular week.

The issue is, each chart is coming one below the other.(Coming vertically). But I need the chart to be displayed horizontally(Left to Right).

How can I achieve this?

Reply

Saranya

December 6, 2011 at 10:11 am

Hi Santhosh,

Currently I have a requirement from my client to display charts horizontally (left to right).It would be great if you could provide your suggestion here, as you were facing this kind previously.

Thanks !!
Saranya.

Reply

Deep

January 23, 2009 at 7:34 pm

hi Shiva,

I have a request where i need to create a YTD actual sell price and YTD budget sell price and annual budget, MTD actual Sell price per region. I have year and month as prompts. The only measure i have is sellprice. I have a degenarate dimension scneario type which wen is ‘ACT’ becomes ACT sellprice and when equal to ‘Bud’ become budget sellprice. pleas help me in creating this report.

thanks

Reply

Supriya

January 28, 2009 at 6:12 am

Hi Shiva,

I have a report with several Request types like ‘Attendee Upload’, ‘CRMOD’…etc,were for each request type it counts how many requests were completed by month in FY09 and I have a Cumulative column at the end which is calculated using summation. I want the Cumulative column to be a running aggregate for that particular service type.

eg. For ‘Attendee Upload’ Request type, 0 days took to complete 1 request, 1 day took to complete 395 requests, 3 days took to complete 898 requests etc.
I want the cumulative column values as 1, 396,396+898=1294 etc. this running aggregate should go only until the last row of the ‘Attendee Upload’ Request type then for the next Request type i.e. ‘CRMOD’ the running aggregate should start form 0 days taken to complete a request.

This is What I have Tried,

1. Selected Running aggregate as an option in pivot table- this doesn’t help as all the columns including months will aggregate, I just want cumulative column to be a running aggregate.

2. Used RSUM by adding another column with the same code as cumulative, even this didn’t help as the months are repeating.

Hope I was able to explain it well.

Please let me know if you have come accrosed such kind of report or if you any idea on how to go about.

Reply

Amy

February 3, 2010 at 9:21 pm

I have the similar report: I need the last number of the running aggregation showing in the top of the page, but not the other running aggregation number. I couldn’t do it. Did you ever get help from the site?

Thanks,

Amy

Reply

Shiva Molabanti

January 30, 2009 at 2:17 pm

Deep,
you need to create first some partitions for sellprice measure based on the degenarate dimension.To do this you have to go in column Fx property in that you have filter tab where you need to give the filter condition like “act” for one time and have same sellprice column again in criteria and give filter in fx as ‘BUD”.
now you have two sellprice columns in criteria 1.ACT filtered and 2.BUD filtered.

To get MTD and YTD you need to generate the TO_DATE() functionality.
otherwise just see one of my article:

Last N months(Rolling months) data By year-month prompt in OBIEE

–Shiva

Reply

Surya

February 12, 2009 at 9:39 pm

Hi Shiva,

I have a bar chart report.I’m trying to customize and I got this problems:

The data label gets positioned at the top of the bar but my customer want to have it in center. Is there anyway to reposition the label?

Thanks in advance.

Surya.

Reply

pankaj garg

February 18, 2009 at 7:25 am

Hello all

I am newbie to OBI EE…and while working on it i got stuck…as per our requirement we need to make charts and put them on dashboards..that’s the easy part…now complex thing is i have to make slider that interact with that chart and the value and shape of the graph changes, as we change the values in the slider area….

Please let me know if it could be done and if yes then please lemme know the method…….

Regards,

pankaj

Reply

pankaj

February 25, 2009 at 5:44 am

hello all

Is thr ny way to define error code and error messages tht wil display on dashboards..i mean is there any poss way of getting the error code and error msg that are defined by user….or is thr any file that contains a list of all error codes and msg’s or in which a user or admin can define code and message

thanks,

pankaj

Reply

Jan

March 3, 2009 at 3:20 am

Hi Shiva,

I’ve couple of questions:

1) what is disconnected analytics? can you please explain?
2) how to integrate .xls in to analytics please?

Thx..
Jan

Reply

Al

March 4, 2009 at 6:07 pm

I want to display total number of records on the 1st Page of OBIEE answer report. How do I do that?

Reply

Shiva Molabanti

March 8, 2009 at 3:59 pm

Al,
You can do this by using narrative view.For this you need to have another column in your answers criteria and write in function like COUNT().

and in narrative view display the count column like @2 (where 2 is the no.of your count column in criteria)
and give value 1 at no.of rows to display section.

and add this narrative view to your compound layout view.

so now you can get total no.of records in your report….

-Shiva

Reply

Jeff

May 27, 2009 at 7:24 pm

doing an rcount in the formula area of a column….the field for this column in the last record is showing the total number of records returned…..in the narrative view I’m refering to this column @#…..issue is the narrative view is showing the value of the first row not the last…….much thanks in advance

Reply
- Shiva Molabanti
  
  November 16, 2009 at 4:11 am
  
  give MAX(RCOUNT())

Ram

March 11, 2009 at 1:09 pm

While adding the logical column and setting the expression with aggreation of sum, i am getting below error when checking the consistency :

ERRORS:

BUSINESS MODEL :
[38083] The Attribute ‘Total’ defines a measure using an obsolete method.

Please let me know how to overcome this.

Regards
Ram

Reply

Shiva Molabanti

March 16, 2009 at 6:10 am

Ram,
Is the Aggregate attribute is the datatype of any numeric family like int,double,float etc…
If not cast them to integer as SUM()aggregation will applicable to only numerical measures.

-shiva

Reply

mehmet

March 31, 2009 at 1:25 pm

chart gösterilemiyor neden olabilir.

Tşkr

Reply

Pratik

April 3, 2009 at 9:07 am

Hi,

I have a problem with applying SUM aggregate on a logical colum.

Requirement is to multiply sum(“Cost * Qty”), but OBIEE does not allow aggregation when calculations applied. I removed the aggregation but found the stupid results.

I got final results as SUM(Cost) * SUM(Qty) which is true for the lowest level (i.e Prod Number), but when i do aggregation to Planning Proj Name it will calculate wrongly bt Sum (Cost) *Sum (qty) group by Pl Prj name.

Do you have any work around to solve this issue?

Any help in this regard is helpful

Thanks in advance

Reply

Shiva Molabanti

April 15, 2009 at 5:25 am

Pratik,
Here you need two check two things.

1.whether The calculation columns are the numeric type or not as you are doing multiplication
2. To get proper level based values you need to set aggrgation to each and evry columns with which you are doing caculation.

If these two are maintained properly you will have no issues like mismatch data.

Thanks
Shiva

Reply

Siva

April 18, 2009 at 5:54 am

Hi Shiva,

This blog is really excellent.
But we are having the scenario where:

In the Date Promt when the user select more than 1 day in the date between prompt, then the message should be display as “Select data only for 1 day”.

Can you please send the Java script for restricting the user to select only 1 day and then display the above message.

Also please let me know how to add more conditions to narrow it down to a single edit box in a particular page.

Regards
Siva

Reply

Suresh

May 4, 2009 at 5:23 am

Hi,

I have to show rsum running across different account, e.g
act1 10
act1 10+8=18
act1 18+2=20
act2 8
act2 8+20=28
act2 28+2=30

I used rsum, but my problem is, OBIEE does differentiate accounts so i end up getting act2 8 +20=28 and so on.
Please help
Suresh

Reply

Shiva Molabanti

May 5, 2009 at 7:16 am

HI suresh,
You have to group by the Measure with accounts_column.then you will get your desired result.
EX: RSUM( BY ACCOUNT_Column).

Thanks
Siva

Reply
- Suresh
  
  May 5, 2009 at 5:34 pm
  
  Shiva,
  
  Thanks for replying.
  I have multiple hierarchies, and rsum should work over both of them, i.e. say time, product and accounts.
  Also lets say Product is like
  product_family, product_group, product_number
  In my report I am showing only product family, and then user is allowed to drill down to product_number, if he wishes to. Will this approche work?
  
  Is there any other alternative?
  
  Thanks a lot

ali

May 21, 2009 at 4:54 am

How can i change the properties of drill down columns is PIVOT TABLE in obiee

Reply

Shahzad

May 21, 2009 at 8:18 am

How can i set properties in Pivot tables drill down columns,and how can i use tooltip on numbers lets suppose,i have an 1234 number and i want to put name as tooltip then how can i get plz help

Reply

valeswar

May 23, 2009 at 8:08 pm

super

Reply

Suresh G

May 26, 2009 at 3:31 pm

Hi SHIVA,
Could u Please tell how to do CASTING in Answers?

Reply

sri

May 28, 2009 at 1:43 am

Hi Shiva,
i have some urgent requirement in OBIEE report. I have four columns one is Dept, Cont no of employees, count no of employees under NJ (where city in New brunswick, edison, newark), Count no of employess under CT (where city in hartford, stamford, new heaven etc). Could you please tell me how to do this? How to put two filters on a same column.

Here in third column having different cities under NJ. I want to count all the employees under each city and the result show them under state of NJ, same as CT.

example is
DEPT ID Count no of employees count no of employees in NJ Count no of employees in CT
ACCOUNT 100 10 4
IT 50 6 30

Thanks in advance
Sri

Reply

Dan Martin

June 3, 2009 at 12:40 pm

Hi Shiva,

I am a OBIEE newbie, a have what would seem to be a very simple requirement that I am struggling with. The requirement is to be able to allow the user to select 2 different time periods (Year and Month) and be able to compare the reuslts in a variance column (ie compare 1/2009 to 2/2008). Any ideals?

Dan

Reply

Michael

April 5, 2010 at 4:46 pm

Did you ever get a response to this question. I’m looking to perform the same type of variance within a pivot table, comparing today’s results vs. yesterday’s results.

Thanks.

Reply
Amy Casavechia

September 12, 2011 at 2:38 am

Hello Dan,

Did you get a reply or suitable workaround for your variance request in OBIEE? I have the same requirement I have been fighting. I need to create variance reports from 2 different time periods and show the 2 values and the variance column all on one line.
Any ideas or suggestions would be greatly appreciated.

Amy C

Reply

kam

June 21, 2009 at 2:12 am

Hi Shiva,
great to find a blogsite like yours.I am a newbee in OBIEE and have an urgent requirement to do follwoing.please help me.Thanks in advance.

one of the dashboard page has date parameters (Between X & Y )and I have to save this date X & Y while next time I reopen this page.how can i do this ?
Please provide steps to do this.

Thanks,
Kam

Reply

kamlesh

June 25, 2009 at 1:32 pm

hey Shiva,

i have a requirement to display the dates which the user enters in the dashboard. if i am using is in it is allowing me to save it in a variable and then later i can use it in the title. but with is between its not allowing me to save it to any presentation variable.

if it is not possible than can you plz help me to give a prompt if the user enters the end date prior to the start date while we are using the is in thing within the dashboard.

thanks,
kamlesh

Reply

Dan

July 12, 2009 at 6:28 am

Shiva,
Just a quick question,I have a Guided navigation used on my dashboard and my objective behind using guided navigation is to display different types of report based on the Report Type (Prompt) selection ,Now when on the dashboard Every thing works fine but on the backgound I can see all the reports running through manage session.Can we avoid this ?

Thanks
Dan

Reply

Jorak

August 3, 2009 at 12:35 pm

Shiva,
Thanks for your help in advance. I have trying to update the default compound layout view in OBI Answers. I have updated the custommessages folder with the answerstemplates.xml for the following message kuiCriteriaDefaultViewElements: Chart, Table, Filter. The requirement is to have the chart, table, filter display by default in the compound view. The table and filter display perfectly as expected, but the chart gives the following error – Assertion failure: pTemplateIDAttr != 0 at line 518 of ./project/webcharts/xmlcompiler.cpp

If I click to the chart in the results view and return to the compound layout view, then all displays appropriately. Please let me know what piece I am missing to achieve the Chart view in the default compound layout view.
Thanks for your assistance.
J

Reply

Deep

August 6, 2009 at 4:59 pm

Hi ,

I am struggling with an OBI issue for last 2 days.

I have two confirmed dimension D1,D2 and two fact F1 and F2 tables.
D1 is joined with F1 ,F2 and D2 joined with F1,F2

We can’t go with the same structure in the BMM Layer. As OBI will throw error if we select field present from D1-F1-F2.

The alternative which I know to resolve the issue is to create alias of the Dimension and then join with the fact in the Physical layer.

If, D1 alias is D1A
And D2 alias is D2A

Then my physical joins will be something like D1-F1-D2 & D1A-F2-D2.

Now In the Business layer I will create a Logical central fact and will join all the facts and dimensions with it.

i.e with the central Fact D1,D2,F1,F2,D1A,D2A will be joined.

This Approach works but I don’t want to put the entire alias in the Presentation Layer. I only want to put the original Dimensions in the Presentation Layer not the alias. So I tried some different approach .

Approach2:

I have not created any alias in the Physical Layer.

In the Business layer I have joined the tables in the following manner.

Create a Central Fact just like my previous approach.
As I have not taken any alias this time so my Cental Fact table is joined with only,
D1,F1,D2,F2.

In the Central logical fact I have created two sources.

Source1

and

Source2

In the Source1 I have mapped the tables as D1-F1-F2
And in the Source 2 I have mapped the table as D2-F1-F2

After doing this I have found that I can able to pick data from all possible combinations.

1. D1-F1-F2
2. D2-F1-F2
3. D1-F1
4. D1-F2
5. D1-D2-F1-F2
6. F1-F2

But I am facing problem only for the condition 2, it is giving the data but when I am picking data from D2,F2,F1 then in the SQL joining condition D1 is also getting joined which should not be the ideal case.

If you know any solution then please share with me. It is very urgent.

Kind Regards,
Deep

Reply

Lavanya

August 8, 2009 at 7:47 am

Hi Shiva,

gr8 to find a blog like this..i found many topics useful to me here…i m new to obiee..

My question is :

In Answers,
I have created three prompts for my report.When i run the report,i can see only one prompt at a time,only if i select a value for it,i can go to the next prompt.The user wants to see all 3 prompts at a time and select values.Is there any way for t?

Also I am using ‘filters view’ in my report to display the value selected by user from prompt as report sub headings.But it displays the static filters given for the report also.How to display only the dynamic filters in filters view?

Reply

surya

October 5, 2009 at 7:13 pm

You are using column prompts. Try using dashboard prompts

Reply

Gustavo Canalis

August 10, 2009 at 7:22 pm

Hi Shiva,
Do you know what the enterprise calendar is about in Project Analytics?
I do realize Fiscal Calendar is GL Calendar and Project Calendar is PA calendar.

But this one seems different than the other ones.

Thank you in advance!

Gus

Reply

Sowjanya

August 11, 2009 at 4:09 am

plase give me u r yahoo/gmail ids.

Reply

vikas barsaiyan

August 20, 2009 at 12:01 pm

Hi Shiva,

I am facing one issue :
I have 4 columns in dashboard prompt.I want to make it mandatory for the user to enter atleast 1 prompt.If he does not enter any prompt then i want a pop up saying “Please enter atleast one prompt value”

Can we achieve this functionality with javascript.Or is there ant other way of doing this.

Reply

Yogesh

August 25, 2009 at 5:58 am

Hi Shiva,

I need to call OBIEE reports from Webcenter/ADF. I need to pass some parameters and get back the result and show on ADF/Portlet.

Cab u guide me the way to get this?

Reply

Yogi

August 25, 2009 at 8:20 am

Hi,
I need to pass parameter from Webcenter/ ADF (may be portlet) 11G to OBIEE and get the report back.

Can you please guide me with steps or sample example.

Thanks in advance.

Reply

jyoti

September 16, 2009 at 3:03 pm

Shiva,

Can you tell me how to restrict the calendar prompt to show only from a specific month in the calendar prompt on the dashboard. I don’t want users to see the dates prior to specific date or month for example: 9/21/2009.

Thanks in advance

Reply

pankaj

September 23, 2009 at 7:56 am

Hi,

Can we show Serial No(1,2,3,4 …) against each row return in report output. How to do it?

Thanks

Pankaj

Reply

Shiva Molabanti

November 16, 2009 at 4:02 am

Pankaj,

For this you need to put RCOUNT() column in report.this rcount() function will be the same how we will have row_num in oracle.

Thanks,
Shiva

Reply
Pramod Kumar Singh

January 14, 2014 at 8:04 pm

use rcount with some pkid column

Reply

Prasanna

September 28, 2009 at 7:55 pm

Hi,

I have a report to show number of opportunities breakdown by week (on Opty created date). I amnot sure how to achieve the weekly breakdown, like it should say 09/21/09, 09/28/09,10/05/09,…like that, can you help me with this?

Thanks,
Prasanna

Reply

surya

October 5, 2009 at 7:12 pm

Hi shiva,

Can we create a drop down box for Dashboard pages instead for a dashboard? Also is it possible to display all the dashboard pages vertically (aligned to left) instead of horizontally? If you have a solution, can you please email me to surya.janjyam@gmail.com

Reply

Kanimozhi

January 10, 2012 at 10:24 am

hi… u ve the solution for this? please share

Reply

Zuber

October 9, 2009 at 5:38 pm

Shiva,

Quick question on iBot.

We have users in obiee who are saving their ibots in shared folder so other users can subscribe to it. problem is once the ibot is saved they are not able to update it.
is there any special setting i need to do so users can update their iBots in shared folder?

Thanks
Zuber

Reply

Parry

February 21, 2012 at 11:22 pm

Hi Zuber,

I am having the same issue, i.e. not able to edit / save the iBots in shared folder. Did you get a solution to this?

Thanks!
Parry

Reply

Vikram

November 3, 2009 at 11:52 pm

Hi shiva
i need to join 2 tables in Physical Layer but they don’t have any direct columns in common
example:

table 1 has ORG_ID = 084

table 2 has Work_id = 08400123

so i need to perform substring operation for work_id in order to get a common column to join them.

how can do that in physical layer of OBIEE..
Please sujjest me a way.
thanks.

Reply

Shiva Molabanti

November 16, 2009 at 4:08 am

vikram,

have complex join in physical layer and give the join condition like:

table1.ORG_ID=SUBSTR(1,3,table2.Work_id)

Thanks,
Shiva

Reply
- srini
  
  December 9, 2009 at 1:48 am
  
  Shiva,
  
  Thanks. I have tried this and this doesn’t work – either using a physical foreign key or a complex join. It throws a syntax error “near “. Even the expresssion builder doesnt carry the substr function.
  
  By the way, the syntax is SUBSTR(table2.Work_id, 1,3)
  
  Thanks

vik

November 19, 2009 at 8:07 pm

Hi Shiva,
Can you please give info on how to implement Disconnected Analytics Application?
Thanks
Vik

Reply

neeraj

November 24, 2009 at 5:10 pm

Hi shiva,
What is time series wizard in obiee? When do you use it?
thanks in advance

Reply

praks

November 25, 2009 at 7:14 pm

Shiva
I have an issue regarding dashboard prompts.
Imagine there are 2 dimensions.Prompts from each dimension are constrained.
But when the second dimension filed values are being selected from the prompt,this dimension is joining through the other dimesion through a fact and then the constrained values are being displayed, which is hampering the performance.We dont have access to data modelling now.From the OBI Side i need your suggestions regd wat can b done and any option of using prompts with out “GO” Button will help?

Reply

Shivin Malhotra

November 27, 2009 at 8:54 am

Hi Shiva,
In some of the report where I display the Facts like Ordered Amount, Invoiced Amount,Operational Backlog Amount and many other measures against the Product Name, the value in the measure column is null always. I checked background query through the session where I found that the measures are not been queried in the database itself,only the Dimension is queried. I checked the formula in the RPD, it is fine.
Am I missing some configuration in the RPD or something else.
It would be of great help if you can help me with this.
I am just a beginner with OBIEE.

Thanks & Regards,
Shivin

Reply

monu

December 3, 2009 at 6:12 pm

hi Shiva,
I am facing an issue. Hope you can help me out with this
I have a table which contains a request key and creation date for the request.
I want to use the drill down feature where i can show the data in terms of year and number of request.if i drill on the number of request in a year i see the number of request according to month and when i click on the request total for a month i can see the distribution for request raised according to week.
I am able to view the total request for a quarter but when i click on a particular quarter i get three columns showing the 3 months of quarter but the request count is 1.I have a request dimension and the time dimension created.
Is this error because i need to make hierarchies in request dimension also.If that is the case how do i do that .My request table jsut has a primary key=req_key and create date column.
I am really stuck on the issue any quick help will be greatly appreciated

Reply

Satya

December 8, 2009 at 3:21 pm

Hi Shiva,

I am trying to implement rolling 6wks, 12wks sum for a particular year in rpd. Can you help me with what functions i should use or logic should be.

Thanks,
Satya

Reply

Karthik

December 8, 2009 at 8:44 pm

Hello Shiva,

Am trying to convert string to date using the following and it always fail. Please help me understand what’s really wrong shiva.

Code :

CAST((’31-OCT-‘ || CAST(YEAR(“Dim – MBS Loan”.”CLOSING DATE”) AS CHAR)) AS DATE)

Error :

View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1840, message: ORA-01840: input value not long enough for date format at OCI call OCIStmtExecute: select distinct D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4, D1.c5 as c5, D1.c6 as c6, nvl(cast(NULL as DOUBLE PRECISION ) , 0) as c7 from (select distinct T518280.PRIMARY_LENDER as c1, T518280.PROJECT_NUMBER as c2, concat(concat(T518199.LOAN_TYPE_1, ‘ ‘), T518199.LOAN_TYPE_2) as c3, T518199.LOAN_CATEGORY as c4, T518199.CLOSING_DATE as c5, cast(concat(’31-OCT-‘, cast(TO_NUMBER(TO_CHAR(T518199.CLOSING_DATE, ‘yyyy’), ‘9999’) as CHARACTER ( 30 ) )) as DATE) as c6 from W_MBS_PROJECT_D T518280 /* Dim – MBS Project */ , W_MBS_LOAN_D T518199 /* Dim – MBS Loan */ , W_MBS_LOAN_TRAN_F T518084 /* Fact – MBS Loan Transactions */ where ( T518084.LOAN_WID = T518199.ROW_WID and T518084.PROJECT_WID = T518280.ROW_WID and T518199.LOAN_STATUS = ‘ACTIVE’ and T518199.CURRENT_FLAG = ‘Y’ and (T518280.PRIMARY_LENDER in (‘HDC’, ‘HPD’)) ) ) D1 order by c1, c2, c3, c4, c5, c6. [nQSError: 17011] SQL statement execution failed. (HY000)

Reply

Hi

December 11, 2009 at 10:26 am

I have one requirement…..have two columns in report A and B and A drill down to C and further C drill down to D and i want that title should get created dynamically with the drill down column name should be shown in title. For eg… When column A drill down to A then title should be A by C and when A column at his lowest level then title should be A by D.

Could you please help me.

thanks & Regards

Reply

Subhash.T

December 18, 2009 at 5:43 am

Hi Shiva,

I have a requirement saying I want all the values even it doesnt meet the oin condition.

I mean see if join condition is met then it will display values pertaining to that join condition satisfaction.
But I want even the other values which doesnt meet the condition also

Give me some solution
Thanks

Subhash

Reply

Usman Fawad

December 22, 2009 at 12:47 pm

Respectable

I am new to OBIEE. I am creating a new request using direct database request. I have created a dashboard prompt of date type. I caught its value in a presentation variable @{test_date} in title which shows date in format like “2008-09-29 09:10:47”.

But sql statement accepts date value in different format i.e. (’29-sep-2008′)

I want this
— where visit_date = ‘@{test_date}’
— where visit_date = ’29-sep-2008′

but i’m getting this
— where visit_date = ‘@{test_date}’
— where visit_date = ‘2008-09-29 09:10:47’

So the scenario gives me no results, I tried much but didn’t found any solution how to pass date. Kindly provide me some clue to solve this problem.

Reply

Usman

January 1, 2010 at 2:14 pm

Respectable!

I am new to OBIEE. It becomes a challenge for me to pass variables from dashboard prompts and to catch their value in Answer’s Request.

I would like to illustrate it with an example.

My desired Request based on the following SQL statement

Select NAME, AGE, CITY, ADDRESS
From emp
Where DOB = ‘@{p_date}’

Now DOB is in TIMESTAMP format,
it looks like ‘11/1/2009 12:00:00 AM’.

Dash board Prompt also depends upon the same column and have also same TIMESTAMP format.

In next step
I create a dashboard page
Place prompt and report there
Saved the dashboard
Now I select a date from prompt list and press go button
It shows no result.

I tried several combinations in @{} syntax e.g.

Where DOB = ‘@{p_date}’
Where DOB = ‘@{p_date}{1-nov-2009}’
Where DOB = cast(@{p_date} as date)
Where DOB = cast(to_char(@{p_date}, ‘dd-mmm-yyyy’) as date)

…. And many other combinations, but i c NO RESULTS

I am looking for any help/tips in this regard

Thanking in anticipation

Usman

Reply

Jay

January 6, 2010 at 6:57 pm

Hi Shiva,

You have wonderful weblog!!

Can we fix or change the size of section in dashboard?

Thanks.

Reply

Sita

January 11, 2010 at 8:03 pm

Hi Siva,

I have a requirement to bring percentage to the calculated measures of two different other calculated measures in the pivot table that created against time…> ((‘Actual’ -‘Plan’ ) /’Plan’)*100.
I changed this to ((‘Actual’ -‘Plan’ ) /’Plan’)*100% but it gave me error. I checked the format and the functions and do not find to fix this. Please help.

Regards,
Sita

Reply

Raghvendra Ghate

January 30, 2010 at 7:17 am

Hi Shiva,
I m new in obiee.
Can you please give me information about how to add page items in tabular report?
Thanks
Raghvendra

Reply

Kalkibabu

February 3, 2010 at 4:44 pm

Hi Shiva,

When i m drilling down on a number ‘123’, it has to retrive 123 records. But i am getting only 67,78 records like that. I have checked the ‘Prompt’ Levels too, but no result. Help me .!!!

Reply

cnu

February 12, 2010 at 12:02 pm

Hi Shiva,

In one Dashboard i have 5 sections.1 section data is coming every 5 sconds.and second section refrshing every 3 seconds.How ro Refresh the particular section in my dashboard.
I tried with Meta tag and iframe using html(In Narrative).But by Using this entire dashboard is refreshing.BUt i want to refresh only section.can u please suggest me how to achive this in OBIEE.

Thanks in Advance
cnu

Reply

April

February 24, 2010 at 9:09 am

Hi Shiva,

We have a new numeric column (ColA) in Opportunity which I need to bring over to OLAP. I created the fact column in W_REVN_F but I noticed that the value is aggregated based on the number of revenues in an opty. For example, the opty has 2 revenue records and ColA is set to 10. When I generate a report that shows Opty Name and ColA, the value shown is 20. Is there a way to modify the formula in RPD so that the correct value is shown?

Thank you for your help.

Reply

praveenak

February 25, 2010 at 10:43 am

Hi Siva,

I have an issue with bar graphs in OBIEE. On a dashboard page i have inserted 5 bar graphs(5 diff requests). When i navigate to that page,graphs which takes few seconds more compared to others in pulling data gets displayed with bigger size. when i click refresh for couple of times all charts will be displayed with same size. Whys is this happening. In siebel analytics we did not face this issue. There everytime all charts were displayed with same size. Please suggest.

Thanks.

Reply

Siddharth Chitre

March 1, 2010 at 6:46 am

hi shiva

can you pls tell me how do i accomodate 13 months in the YTD function? By default YTD only takes 12 months as its time period

Reply

Himanshu

March 2, 2010 at 12:46 pm

Hi..I am implementing YTD report however i have to generate it without a specific olap database..The OLTP table i have to generate the report against looks like this..
SNo Dealer SaleDate #CarsSold
1 hyundaiA 1/1/2009 10
2 hyundaiB 20/5/2009 25
3 hyundaiA 15/2/2010 35

I modelled the above physical table as the following 3 tables in my business layer. All the 3 tables are based on the same OLTP table in my physical layer

Dealer Dim Table with the following logical columns
SNo
DealerName

Time Dim Table
SNo
SaleDate
SaleYear-Derived by applying Year function to SaleDate
SaleQuarter-Again derived from SaleDate
SaleMonth-Again Derived from SaleDate
SaleQuarterDesc & SaleMonthDesc as suggested by you above by appending year and quarter etc

The chronological keys while creating timeDimension is defined appropriately at all levels and at lowest detail level it is defined as SNo.

Sale Fact Table contains follwing columns
SNo
#CarsSold

All the 3 tables are being derived from the one and only physical OLTP table i have. the facts and dimensions are realted by column SNo.

I followed all the steps to create a YTD but not getting appropriate results. I am not getting error but getting wrong results. Kindly let me know if what am trying to do is indeed possible and if you can determine where i am going wrong. I am new to OBIEE and chances are I might be going fundamentally wrong somewhere.

Reply

razvan

March 29, 2010 at 2:44 pm

I have a twelve column table, each column with different filters on same measure in fact table. Say filter one to column a (number of persons existing at 01-01-2003) is from dimension persons (date_of_birth <= '01-01-2003'). Filter two to column b (number of persons living in Bucharest between '01-01-2004 and '01-01-2006') is (date_of_birth between 2004 & 2006) etc.
How can I use column a & column b into same result table (view)? I need different filters on same table.

Thanks!

Reply

seiciu

April 4, 2010 at 5:08 am

http://forums.oracle.com/forums/thread.jspa?threadID=1053058&tstart=0

I have a saved report R1 : person_id, max(date_of_last_address). The idea is last persons home address.
I have another report R2 : persons, day_of_birth, home address, date_of_address, district, company, departement, date_of_job,nr_of_persons(measure)

I know that using filter F1 : person_id is in R1 and date_of_address is in R1 (using person_id and max(date_of_last_address)) works at report level.

I want this filter *(F1) to be at column level* (on formula of persons and date_of_address) because i want *different filters on different columns in same report*.

Example : I need max(date_of_address) and max(date_of_job) filtered in same report at column level.

Thank you!

Reply

Rasheen

April 7, 2010 at 5:28 pm

Hi Shiva,
Please could you let me know, how to load Fiscal Week information into OBIEE if we do not have Fiscal weeks set up in Oracle Apps (Source).

Thanks
Rasheen

Reply

Antonio

April 8, 2010 at 1:17 pm

Hi Shiva,
I’ve a problem with the IN statement. I select 2 values from prompt (i.box and I.Box) and the query is created in the right way, but when I read the report I find just a value (i.box). If I put a LOWER/UPPER function I see all chosen values. How can I solve this problem without using Upper/Lower function?
Thank you
Antonio

Reply

Dhritiman

April 22, 2010 at 12:35 pm

Dear Shiva,

I have faced a problem during deployment of the .rpd file in Linux machine.

Here are the system details –

Linux : 2.6.9-89.0.9.ELlargesmp #1 SMP Wed Aug 19 08:12:11 EDT 2009 x86_64 x86_64 x86_64 GNU/Linu

OBIEE : biee_linux_x86_redhat_101341.zip
JAVA:jdk 1.5
Oracle Client:10.1.0.2.0
There is no firewall as well as no anti virus.

We are using sh.rpd. After login, we go to the answer select some fields. When we are trying display the result, it shows the processing status, nothing else. Though it is working fine in windows and other linux box.

Could you please help me out?

Thanks,
Dhritiman

Reply

Aman

April 28, 2010 at 8:52 pm

Hi Shiva,

In calender, IF I have selected date range between 2/2/203 to 2/4/2020. If particular Month doesn’t have data how would I show 0 count there…… User don’t want to see any gap between month– it should be in order like JAN to DEC, IF NOV Doesn’t have data– it should show as 0 count there….

Can you please help me out how to do it.

Thanks,
Aman

Reply

RAGC

August 25, 2011 at 11:05 am

Hello,
Could someone help me? I have the same issue as Aman posted before, has anyone the solution?
Thanks in advanced.

Reply

Rushi

May 5, 2010 at 10:20 am

Hiiii Shiva, glad to talk with u after a long time, i think u remind me, i am from kpipartners offshore.

Here i want to know one thing, i want to achieve one criteria in DashBoards such that
I want to see all pages of my dashboard without scroll…I mind…If I have 15 pages of my dashboard I would like to see “two lines”. One line with 8 pages and another of 7 lines for exemple.

Thanks & Regards

Reply

rushi

May 5, 2010 at 10:24 am

Hi Shiva, Glad to talk with u after a long time, hope u remember me, Rushi from KPIPARTNERS offshore.
Here i have a doubt regarding the dashboards
I want to see all pages of my dashboard without scroll…I mind…If I have 15 pages of my dashboard I would like to see “two lines”. One line with 8 pages and another of 7 lines for exemple.

Reply

rushi

May 5, 2010 at 10:25 am

Thanks & Regards

Rushi

Reply

Patrick

May 18, 2010 at 6:21 pm

Hi Shiva,

I really like yoru posting about case insensitivity in the dashboard prompt. Thank you for that. I was hoping you could help me on another issue I am having. I would like to be able to ‘Tab’ in the dashboard prompts when we have set an ‘is between’ rule. So for instance when we have text boxes for dates and we have the user pick two seperate dates. I would like it so they can tab from one text box to the other without the prompt refreshing. Currently the prompt refreshes and takes the focus off of the next texty box. Is there a way we can have it not refresh on text boxes or put the focus on the next text box in the prompt?

Any help is greatly appreciated.

Thanks,

Patrick

Reply

Martien

May 19, 2010 at 7:14 am

iBots are scheduler using the regular Gregorian calendar. However the company that I work for uses a fiscal calendar. E.g. January month-end doesn’t necessary fall on Jan 31st, but could be the 29th.

We have given this some options and came with a ouple of ideas:
– run a program that will reset the iBot’s next run time based on fiscal calendar.
– implement a database trigger that will reset the iBot’s next run time based on fiscal calendar.

We were able to revderse engineer all the columns in the nq_job table.

However we haven’t come up yet with a database procedure to implement this.

The scheduler’s tables are in an Oracle database.

Could you write up something?

Reply

Shruthi

May 20, 2010 at 9:40 pm

Hi Shiva ,
When I create reports in the Answers section there are several places where you can ‘format’
your columns. But wherever I enter a value in the ‘width’ field of the ‘Additional Formatting Oprions’ section on the ‘Value Format’ section of the column properties, the width seems to
remain the same in the report. How can I steer the width of columns in the OBIEE answers reports?

Thank you in advance

Reg
S

Reply

skumar

May 24, 2010 at 6:46 pm

Hi Shiva,

I have a requirement where I need to pop up an error message asking the user to enter a valid value for a prompt. i.e if the user doesnt select any value ( = NULL) in the prompt and clicks the GO button, then the custom message should pop up – “Please enter valid value for the prompt”

This is something similar to the date validation post in your blog. Can you please give me the solution to this requirement.

Reply

Ranjith

June 7, 2010 at 5:06 pm

Hello Shiva,

Would u pls let me know about the alias table in the physical layer?? It would be gr8 if you can provide a detailed explanation the alias table for what purpose we use it and how do we configure? with a suitable example? because this question is asked by every interviewer

Explain it in a layman terms pls

Thanks & Regards

Ranjith

Reply

Deepak

July 2, 2010 at 1:20 pm

Hi Shiva
I want to use presentation variable for the between clause in my dashboard prompt. By default when I had between clause in my dashboard prompt it does not give option of setting variable.
Just wondering if there is any other way to do that.

Deepak

Reply

shabbir

July 6, 2010 at 11:20 am

Hi shiva,
How can i pass a date value in chart title so that if any date is selected from the prompt it should display
that date in the chart title.

thanks in advance

Reply

Siva Kumar Budagam

August 25, 2010 at 11:18 am

Hi Shabbir,

I Hope that can be possible by creating ” Presentation variable”.
As per my knwoledge
just create a prompt on Date Column and assign a Presenation Variable to that Prompt.

Now just Call that Presenation variable in Chart Title by ” Report You Have selected for the date: @{Presenation Variable}{Default Value}.

Hi Shiva,

Let me know if i gone any thing wrong.

Thanks in Advance.

Reply

allam

August 6, 2010 at 2:24 pm

Hi siva,
please can you send the answer for this issue.

–>Show data loaded date and drill down instructions at top of all charts
At the top of each chart, how can we add “Data Loaded on XX/XX/XXXX” label. Also, put “Click graph to drill down” on all graphs where applicable.

Reply

shilpa

August 11, 2010 at 10:45 am

hi..
how can we generate reports for a particular time period in obiee

Reply

Need to use 5000 values from excel to filter answers report

August 12, 2010 at 5:04 pm

Shiva,

This is some great work. My company needs a workaround solution for the business, without having to make lot of changes to RPD metadata. The requirement is to upload about 5000 serial numbers that need to be used a filter values for a reports in Answers. The 5000 number are in a excel spreadsheet.

I proposed a solution, to load these to a standalone table and add it as an additional source to the logical asset dimension, which works, But the company does not want to make any changes to the metadata as this i s not a standard OBIEE requirement.

Any help will be greatly appreciated.

Best Regards,
Sendhil

Reply

vamsi

August 16, 2010 at 10:29 am

Hai shiva
Is there any option to arrange the dashboard pages in horizontal way………..

Reply

Bharath

August 19, 2010 at 5:58 pm

Hello
I want to arrange the dashboard prompts in a sequence irrespective of the column names length
so is there any possible way to do so.

Thanks in advance

Reply

Siva Kumar Budagam

August 25, 2010 at 11:12 am

Hi Shiva,
Could you please expain the concept of Alias Table in OBIEE.

How it is going to Avoid the circular Join.?

the purpose of Alia Table in OBIEE..

Reply

Manish

August 25, 2010 at 7:44 pm

Hi Shiva,
I want to create a column with average of last 6 months sales data. I do have the sales data . I want it in such a way that if I just choose the month in the prompt it will give me the average of past six month sales from that month chosen month. How can I do this?

Reply

Jithu

September 1, 2010 at 2:23 pm

Hi Shiva,

I have problem with the dashboard prompt on the product list as i have selected multi-select option in the control when i am trying to enter it in the lower case it shows as no-choice found for any value present in the list. Can u please help with the solutions as i need to get the values as i entry them in lowercase as well?

In the table, the values are in the uppercase so i need to get the values when i entry lower or upper? currently i do get when i entry in uppercase?

Reply

Brindha

September 14, 2010 at 4:20 pm

hi shiva,
i am new to OBIEE.is it possible to merge two subject areas from different rpds into single subject area?

Reply

sasikiran

September 24, 2010 at 12:37 pm

Hi Brindha,

Try this…

http://st-curriculum.oracle.com/obe/fmw/bi/biee/r1013/merge/merge.html

Good luck…

Regards,
sasikiran

Reply
- Brindha
  
  October 9, 2010 at 5:42 pm
  
  hi Shashi,
  thanks for your response.can you suggest me any good reference sites for obiee.

Suneel Doddapaneni

September 20, 2010 at 8:35 pm

Shiva,

I wanted to add a text field to produce a table of results. I can do it by adding a prompt.
But the problem is, I want to use this new prompt for only this particular table on the page.
This page has other charts/tables with prompted filter on same field (I have a prompt on same field on the top of the page). But I want to use a different prompt for the same field which specific for only one table (don’t want page prompt). Is it possible to achieve this any way?

Reply

sasikiran

September 24, 2010 at 12:28 pm

Hi Shiva,

Nice to know about you!!!

I’m new to OBIEE, browsing lots of portals / blogs and gathering OBIEE material and learning. I’ve lot of questions but I don’t have anybody who can answer queries in my space, appreciate if you respond to me via email.

Many thanks in advance

Regards,
sasikiran

Reply

Jagadeesha

September 28, 2010 at 9:39 am

hi, I m new to OBIEE. plz help me by suggesting the way to learn OBIEE. and also suggest good tutorial

Reply

Jyoti

September 29, 2010 at 6:46 am

HI Shiva,
I have one report requirement in which i want to calculate cumulative sum of sales.
How to achieve this in obiee.

Locking forward for your quick reply.
Thanks
Jyoti

Reply

sirisha

July 20, 2011 at 4:03 pm

Hi Jyoti, did u get answer for this even I have the same requirement

Reply

Saran

October 28, 2010 at 3:15 am

Hi Shiva

We are using
Oracle Business Intelligence Product Version 10.1.3.4.1 (Build 090414.1900)
with IE-8 /IE-6/mozilla3.0/mozilla3.5 (diff users were having diff browers) , but the problem is same

We are facing issue in BI answers (Presentation server is in Linux box/Oracle Appl.server) ,
The compound layout drop down shows none of the views , i mean we could the see any of the pivot table ,chart views etc and the entire session gets hanged up , its not allowing to navigate any other options

But when i run my local laptops presentation server(OC4J) to access the paint dashboards , i didn’t see any isue.

Pledase do respond

Thanks

Reply

krishna

November 3, 2010 at 7:20 am

Would it be possible to provide a popup(Report has to display) by clicking on one of the line bar point?

Reply

krishna

November 3, 2010 at 7:21 am

Would it be possible to provide a popup(Report has to display in the same page) by clicking on one of the line bar point of a line graph?

Reply

Marina

November 5, 2010 at 1:00 pm

Hello, I am new to OBIEE.

I need to know how to display the dashboard pages vertically

I followed the steps in this blog “http://forums.oracle.com/forums/thread.jspa?threadID=1014941” but did not return any results.

I followed the steps explained in the posts related to my questions in the OTN Discussion Forums “http://forums.oracle.com/forums/thread.jspa?threadID=1014941” but have not obtained any results.

I am desperate. Please help me.

Thank you very much.

Reply

Kanimozhi

January 10, 2012 at 10:25 am

hi… do you ve a solution for this? please share

Reply

Corinna

November 11, 2010 at 3:03 pm

Hi Shiva,

Is there a way to reduce the sensitivity of the search capabilities within OBIEE. For Instance when a user has a list of variables to use in their prompts, when typing in the first few characters to “jump ahead” in a long list, OBIEE responds faster than our users can type therefore it is removing all usabilty of the feature since they are still left to keep scrolling.

Thanks,

Reply

Satyaprakash Paul

November 17, 2010 at 6:40 am

Hi Shiva,

how to change angles of data levels of graphs in OBI EE, Because I am showing data labels at the top of each vertical bar of a bar chart. the data labels are of 4 digits, data level of a vertical bar is cuting the consigutive vertical bar(if the consigutive vertical bar is taller than this),

I think if I can show the data labels virtically(in 90 degree angle) The problem will get resolved.

can you please suggest how to change angles of data levels of virtical bars in a bar chart in OBI EE.

Reply

BI Person

November 18, 2010 at 5:58 am

Hi,

Great job Shiva. Can you include my blog into ur blogroll.
http://unleashobiee.wordpress.com

Reply

krishna

November 25, 2010 at 6:39 am

HI,

can we create a Check Box Prompt as a dashboard prompt in OBIEE

Thanks & regards

Krishna

Reply

Ananjan Chaudhuri

November 30, 2010 at 7:07 am

Hello Shiva,

My name is Ananjan Chaudhuri and I work for Packt Publishing, a U.K. based publishing firm specializing in focused IT books. You can read more about us here: http://www.packtpub.com
I came across your blog via a Google search and noticed a good amount of relevant information and blog updates related to Oracle Hyperion.

I would like to inform you that Packt has recently published a new book The Business Analyst’s Guide To Oracle Hyperion Interactive Reporting 11, a book that provides strong relational querying and data analysis capabilities. Written by Edward J.Cody, this book demonstrates the key functionalities of the Oracle Hyperion Interactive Reporting software with a detailed view of each section and an introduction to dashboard design . You may read more about the book here:- https://www.packtpub.com/oracle-hyperion-interactive-reporting-11-1-business-analysts-guide/book

Keeping in mind your knowledge in this subject and having looked at your contributions, I feel you’d make an excellent reviewer of this book. In case this subject interests you and you’ d like to go through a copy, simply let me know your shipping details and I’ll have the eBook added to your account and would provide you with the download instructions in my next e-mail. You can then download this book instantly.

If you have any queries, do let me know and I’d be happy to assist.

I look forward to hearing your thoughts on this.

Have a good day!

Ananjan.

Reply

krishna

November 30, 2010 at 12:53 pm

Hi

1. Would it be possible to provide ranking on graphs by department based on their actual sales?

2. If ranking is possible, Would it be possible to sort the department vertical graph bars by ranking?

If not possible, please provide me the the alternative solution?

Thanks & regards
Krishna Mohan

Reply

Rishi

December 1, 2010 at 11:51 am

Hi shiva,
1.I would like to know how to introduce a new font type in to OBIEE_11g.I tried to change in the path E:\OBIEE_11g\Oracle_BI1\bifoundation\web\msgdb\messages/commonuitemplates.
Newly introduced font is already added in control panel/fonts also.
But it showing me an error while i selected the newly introduced font in the style tab of column properties.

Error:Datatype error:InvalidDatatypevalue exception, Message:value
“Baroquescript’ is not enumeration.

Can u please suggest how i will get rid of this error and to get the new font works fine.

Thanks
Rishi

Reply

Rishi

December 1, 2010 at 11:52 am

Hi shiva,
1.I would like to know how to introduce a new font type in to OBIEE_11g.I tried to change in the path E:\OBIEE_11g\Oracle_BI1\bifoundation\web\msgdb\messages/commonuitemplates.
Newly introduced font is already added in control panel/fonts also.
But it showing me an error while i selected the newly introduced font in the style tab of column properties.

Error:Datatype error:InvalidDatatypevalue exception, Message:value
“Baroquescript’ is not enumeration.

Can u please suggest how i will get rid of this error and to get the new font works fine.

Thanks
Rishi

Reply

krishna

December 2, 2010 at 9:27 am

Hi

1. Would it be possible to provide ranking on graphs by department based on their actual sales?

2. If ranking is possible, Would it be possible to sort the department vertical graph bars by ranking?

If not possible, please provide me the the alternative solution?

Thanks & regards
Krishna Mohan

Reply

kalyan

December 3, 2010 at 1:21 pm

Hi Shiva,

This is Kalyan JV.

Iam facing a problem in configuring the OBIEE 11g in SSO ( Single Sign On )configuration using OID.

Could you please help me in regaring this asspect.

Reply

Ravindra

December 15, 2010 at 12:04 pm

Hi Shiva,

This is ravi, I am intresting to learn OBIEE, But i am new in obiee, So

Please tel me the future about OBIEE and How many types of tools there in OBIEE Like administrator and dashboards.

Thanks in Advance,
Ravi.

Reply

Mousumi

December 20, 2010 at 6:52 pm

Hi
I have around 1lk record in a Education fact table.There is a column called University name.We don’t have any Dimension for University.The requirement is user wants a search on dashboard prompt based on University.Is it recommendable to make a prompt directly from fact table or shall I proceed with a new University Dimension and do teh report make the prompt from University Dimension column?

Reply

Anjali

December 23, 2010 at 7:51 pm

Hello Shiva , can you please help me with this .

I have the below scenario . Iam trying to get the grand total for a calculated column(variance) . I tried several ways …like report aggregates enabled in instanceconfig,tried creating cal colum using physical columns as well as logical columns in RPD , changing the aggregation rule to get it right but all in vain. The row wise values are coming correct but iam unable to get correct grand total instead iam just getting the sum of the total which is not used . I have tried the above options in my previous reports and those conditions work perfectly right but for this report they are not able to . If i dont use Sum By I cannt get the values by department , instead i just get one common total for everything.
kindly please let me know if there is any solution for this issue .

Example ”
Department …ACT BUD Varianc(Sum(ACt by Dept)/Sum(bud by dept)*100)

XYZ 10 20 50%
ABC 25 75 33.3%
Total 35 95 36.8% ( 35/95)

Thanks
Anjali

Reply

galway

January 3, 2011 at 8:18 am

How to add new charts like Donought chart in OBIEE? Any one?

Thanks,
G

Reply

sandeepa

January 26, 2011 at 9:38 am

How to create a chart in OBIEE? I don’t have any idea how to add a measure.

Reply

sandeepa

January 26, 2011 at 9:40 am

How to create a chart report in OBIEE? Don’t have nay idea how to add measures.

Reply

redver

February 1, 2011 at 11:51 am

Hi there!
Can get OBIEE shared folder from a user over an URL Parameters?? Like a xml with info or something?
And can I request something with SOAP?

Thanks

Reply

AJ

February 1, 2011 at 10:15 pm

Shiva,

I have upgraded my rpd from 10 to 11 and configured LDAP in weblogic and authentication works fine. Now unable to interate OBIEE with BI publisher in 11.Is there any security congigurations need to be followed in weblogic security. Pls let me know if you got any documentation on the same.

Thanks

AJ

Reply

Brian

February 4, 2011 at 1:52 am

Hi,

We have reports that have several prompted fields.Some of these fields required fields.Is there a way (other than setting default values) to enforce a mandatory prompt.Please help Thank you

Reply

Lyn

February 8, 2011 at 1:00 am

Hello, Shiva,

Thank you for your posting on
TIP #1:Export BI Catalog captions from command line in OBIEE 11g …

TIP #1:Export BI Catalog captions from command line in OBIEE 11g

Would like to check if similar function available in OBIEE 10g?

Thanks,

Reply

vkrishnak@gmail.com

February 8, 2011 at 9:11 pm

How do u calculate % variance when the numerator or/And denominator can be nulls using OBIEE? I have tried case when ifnull(den,0) =0 and ifnull(num,0)=0 then 0 when ifnull(den,0) =0 and ifnull(num,0)0 then 100 else
100*(num-den)/den
This didnt work. Do u knw any solution?

Reply

Andy Tran

February 12, 2011 at 8:30 pm

I’m trying to run RUNCAT.CMD with the online switch, but I can’t get it run properly. Am I doing it right?

runcat.cmd -cmd unarchive -online http://localhost:9704/analytics/saw.dll?catalog -credentials d:\boot.properties -inputFile D:test.catalog -folder /users/weblogic/_filters -acl preserve -overwrite force

Reply

Nalini

February 13, 2011 at 7:07 pm

How to use the time stamp to get the data for last 1 month, 2 to 4 months and greater than 1year and show it in pie chart. Any help would be appreciated.

Reply

Naveen kumar

February 16, 2011 at 5:39 am

Hi Shiva,
Glad to meeet u.

Here i have requirement.Navigate from one report to another.

Eg: i have one column
ACCESS_TYPE
101,
102,
103,
104.

when i am trying to click any one of the above values it should navigate another report.like the second report have detailed data.
here prob is when i click on the 101 it navigates to 2nd report with detail data. but i need when i am trying to click on 101.the 2nd report should display data based on what ever filter i given in 1st report i.e.,101.it should give 101 data only.

Can give the solution how to achieve it.

Thanks,
Naveen kumar

Reply

sravankumar boggarapu

February 21, 2011 at 5:37 pm

Hi Shiva,

Great work!!! Could you please write a posting on SSO and securities implementation in OBIEE 11G

Thanks in Advance

Reply

Nagesh

March 1, 2011 at 9:13 pm

Hi Shiva,

It was pleasure reading your blong and Aske part of it.
I have small issue with sh.rpd that I’ve downloaded from
net. The saved filters folder is empty, I have not deleted
any filters from it.

Can you please guide me how to get it.
Also can you guide me how to create a filter showing last 12months results.

Thanks and have a great day
Nagesh

Reply

Jeetu

March 2, 2011 at 12:17 am

Hi Shiva

Thanks for the wonderful work. My client has a requirement in OBIEE 11g as follows.

Reports are sent through e-mail every week. But they want to have the dynamics of drill up /drill down in the excel downloaded copy of the report using + mark sort of collapsible view. How can we achieve this.

Also, when there are multiple reports to be sent to same receipient, what is the best delivery channel via e-mail?
I mean, they don’t want to send 5 different attachements nor ZIP files. Is there any inventive way which pleases business??

Thanks in advance
Jeetu

Reply

Nagesh

March 2, 2011 at 11:10 am

Hi Shiva,
It was a pleasure reading your blog and I enjoyed it. I have questions, How can I create a report to generate 12months values to display from sh.rpd. Incidentally, the saved filter folder is empty on sh.rpd.

Thanks
Nagesh

Reply

xuna

March 10, 2011 at 1:57 am

Hi Shiva,

I was doing the YTD and MTD sale achieve in my report, but when i drag the YTD and MTD into pivot table, the value become incorrect, for YTD, It sum up all the YTD. How should i do??

Reply

daledo

March 14, 2011 at 4:43 pm

Hi Shiva,

I have a Most Recent 12 months filter set in OBIEE11g which is resulting in correct data. My issue is how to have it return the all of the months even if there is not any sales during that particluar month? Also, when graphing the data, the horizontal axis will show each sales date, is there a way to group the horizontal by month and plot within the correct month?

Your post was very helpful!

Reply

Nipun

March 16, 2011 at 2:02 pm

Hi Shiva,

I’m facing one issue with the Calendar Type Prompt in OBIEE 11g.
I referred your post on “OBIEE IS BETWEEN Date Validation for dashboard prompt” but could not able to do much as i could not locate “globalfilterprompt.js” file in OBIEE 11g.

Seems like this file has been renamed in 11g. did lot of R&D on the same but could not locate the script file.

could u pls help me with the same in OBIEE 11g.

Regards

Reply

jack

July 28, 2011 at 1:31 pm

ı have faced this issue too and can not find any solutions yet…ı will be appreciated for your help

best regards

Reply

Suresh

March 27, 2011 at 2:24 am

Hi i got a requirement which looks like this
id type person Count
1 Ongoing Stella 0
2 Ongoing Nick 0
3 FCC Sam 1
4 Ongoing copter 0

my question is if i click on count values it should navigate to a report and based on type column value it should pass filters that is if type is Ongoing it should pass 2 filters if type is FCC it should pass three filters. but i am clicking on count values not on type column.

Thanks

Reply

Dipak

April 18, 2011 at 3:29 pm

If I have a requirement where I need to publish report as follows –
Current Date: 1 Jan-2012
====================================================================
Q1 Total = 100
—————————–
Q2 Total = 200 Quarter on Quarter difference = 100
—————————–
Q3 Total = 400 Quarter on Quarter difference = 200
—————————–
Oct-2011
Toal = 200 Difference since last quarter = 200

Nov-2011
Toal = 150 Difference since last month = 50

Dec-2011
Total = 250 Difference since last month = 100
———————————
Q4 Total = 600 Quarter on Quarter change = 200
==================================================================
Please Note:
a] In my system I am loading data month wise.
b] For current quarter it should segregate month wise.
i.e. Q1 report will give details of JAN-FEB-MAR,
Q2 report will give details of APR-MAY-JUN,
Q3 report will give details of JUL-AUG-SEP.
====================================================================

How to create such a reporting?

Reply

AKS

April 25, 2011 at 7:41 am

Hello,

Can you please please tell me how to purge cache in unix obiee.

Thanks

Reply

Gerrit

April 27, 2011 at 12:16 pm

Hi Shiva,

Great blog. Noticed you have SSO experience in OBIEE 11G. How do you translate the following config to 11G.

Thanks in advance…

Reply

Gerrit

April 27, 2011 at 1:28 pm

Hello Shiva,

Learned a lot from your blog… I have an OBIEE 11G config problem. Can you please post a guide on how to implement SSO trough Http Headers on Weblogic Server?

Thanks in advance…

Reply

FR

May 2, 2011 at 10:37 am

Hi Siva,
I am very new to OBIEE……i have acheived naviagting from the Master report to Detail Report.. but what i also want is my deatil report should appear at the right of Master report based on my click of record.. Kindly help..

Reply

chandra

May 3, 2011 at 5:36 pm

Hi,

I want to calculate last three months average dynamically in pivot table view. So, How to do that? Please suggest.

Reply

Shyly

May 17, 2011 at 5:01 pm

Hi Shiva,
I have always followed your blogs to implement and explore new things.
Currently, I am working on SSO Implementation in OBIEE 11 G and I have seen in your profile that you have implemented it.I am unable to find any documents with the implementation steps.
I know that the steps will not be the same what we used to do in Siebel Analytics/Obiee 10 G.
Can you please provide any document to follow or guide me as I am completely stuck.
Many Thanks.

Reply

SHyly

May 19, 2011 at 9:32 am

Hello Shiva,

Learned a lot from your blog… I have an OBIEE 11G config problem. Can you please post a guide on how to implement SSO trough Http Headers on Weblogic Server?
How to do Impersonation and Configure SSO /SM Authentication in OBIEE 11 G.

Thanks in advance…

Reply

Mahesh

May 21, 2011 at 7:00 am

Hi..
In recent interview i vounterd with this question.
What are the disadvantages of Pivot table?

Does anyone know the anser..

Thank you

Reply

Karan

May 25, 2011 at 10:11 am

Sub: Creating BI report with 2D stacking for two different variables legend axis

Hi,

I am trying to make a report where on X-axis I need $ value, and on Y-axis I need a combination of 2 database fields (say customer and sales territory) stacked as a 2D/3D chart. I need to display such top 21 combos, so 21 bars on Y-axis. (For Ex. If 4 sales territories, then for every customer, there would be four customer and sales territory combos).

Also, I need following legends as bars – type of sales and type of customers as in I have four such legend options: Credit-Premium, Cash-Premium, Credit-Normal, Cash-Normal.

Any pointers how to do that and if I need any sub queries to handle that?

Thanks.

Reply

Vind

May 25, 2011 at 11:29 am

Hi siva,
Good work!!!
I’m new to obiee.
how to add compound layout view in answers. please reply

Reply

Purush Thirumala

May 25, 2011 at 5:04 pm

Shiva, can you please help me to create a calculated column for “Rolling Average Daily Net Sales”. I created Average Daily Net Sales calc and it works fine and numbers are accurate. The report runs as of prior business day. Please help.

Calc for “Average Daily Net Sales” and I need calc for “Rolling Average Daily Net Sales”:

ifnull(FILTER (“- CoverSheet Fact”.MTDNetSales USING (“- Calendar”.”Calendar Date” = cast(cast(month(VALUEOF(“Previous_Day”)) as varchar(2))||’/’||cast(day(VALUEOF(“Previous_Day”)) as varchar(2))||’/’||cast(year(VALUEOF(“Previous_Day”)) as varchar(4))||’ 00:00:00′ as date))) / max(case when “- Calendar”.”Calendar Date” = cast(cast(month(VALUEOF(“Previous_Day”)) as varchar(2))||’/’||cast(day(VALUEOF(“Previous_Day”)) as varchar(2))||’/’||cast(year(VALUEOF(“Previous_Day”)) as varchar(4))||’ 00:00:00′ as date) then “- Calendar”.”Business Day of Month” else 0 end),0)

Reply

Vbhat

January 6, 2012 at 10:50 pm

Use the BI function MAVG (expr, integer) – Calculates a moving average (mean) for the last n rows of data in the result set, inclusive of the current row.

Go to the Presentation Column–>Functions–>Running Aggregate–>MAVG

Reply

Karan

May 30, 2011 at 12:30 pm

Hi,

I have a query. I have made some reports in OBIEE, with “region” as a page prompt for report filteration. I have also defined region related roles using jsp pages in my OBIEE Instance. Now if a user has access to no region and in that case, if he/she tries to access a report, how to we display an error saying that “You don’t have adequate access”?

Thank you.

Reply

Karan

May 30, 2011 at 12:32 pm

Hi,

I am trying to work on some jsp pages in OBIEE for doing some mapping in order to finalize some data in my OBIEE (to be used for OBIEE reporting). However, whenever I click on any field on the jsp page (in Internet Explorer)for an existing record, my cursor points to the beginning of the field and not towards the end. No such issue is there in Mozilla or other browsers. Is that a known issue?

Regards,
Karan

Reply

Pavan

June 1, 2011 at 3:28 pm

Hi Shiva,

Could you let me know how the pre built rpd is designed and any doc’s for BI AnalyticsApps.rpd

Thanks,

Reply

Cash

June 1, 2011 at 6:05 pm

hi
I’m new to answers so any help would be much appreciated. I have several reports on a dashboard page, I would like to allow user to choose time period via a javascript radio button such as:
(*)Weekly
( )Monthly
( )Quarterly
Then in the reports set a column called period based on the value of the var. THis way I could develop just one report that displays based on the period var rather than making three different versions of the report. Can anyone give me step by step instructions and example of how to do this.

Thanks very much in advance!

Reply

Cydabuan

June 14, 2011 at 5:18 pm

Any experience/ideas regarding the use of Type 2 SCD approach to capture change history for fact tables? I’m on an OBIEE project that deals mostly with inventory balances as facts. The facts are not cumulative, so the total for a given period is less important as say what the value was at a particular point in time (usually at the end of the billing month) or what the average/min/max was over a specific time period. These facts don’t change often (we see anywhere from 100 – 300 balance changes a month for 18,000 accounts).

From a modeling standpoint, I’ve read about using Start/End Dates (Type 2) on fact tables to avoid having to take the performance/capacity hit of daily snapshots of everything. But it doesn’t seem to me that OBIEE Answers could handle this design very well. Can you shed some light?

CDBA

Reply

Kalesg

June 14, 2011 at 6:42 pm

Hi Shiva,

I have a source code and need to find tables create a rpd
An existing RPD has been created .net and I need to do it on Obiee – can u help me please

ASAP

Thanks in Advance

Reply

Can we customize " View Display Error" in OBIEE

June 15, 2011 at 11:12 am

Can we customize ” View Display Error” in OBIEE

Reply

ss

June 19, 2011 at 5:16 pm

Hi, Is there any way to hide the Edit button in MultiSelect prompt?

Reply

Chandu

June 20, 2011 at 9:28 am

Hi Shiva,

We have a requirement to create a report in BI Publisher from two different databases one is from Oracle database and other is from MSSQL. But when we creating the JDBC Connection we can create only one connection at a time.
Can you please let me know whether we can do this or not. If yes please let me know how?

Thanks in Advance

Reply

Girish

June 21, 2011 at 1:55 pm

I am facing an issue in anOBI report. There is a prompt FW from and FW to. Columns in report give valuesaccording to the FW range except one column should give cost for selected FW-1and selected FW -2.For eg:I select Fw from 5 to 13.Column ‘prior twoweeks’ should give cost for FW 4 and 3.There is problem in getting valuesfor ‘prior total weeks’. I need help in this issue as soon aspossible.

Reply

Sunil

June 23, 2011 at 3:14 pm

Error Installing OBIEE Software Only
I am trying to install OBIEE 11g Software on Windows 64 bit machine, as I want to use the scale out option going with Software Install Only.
The Oracle documentation is says if we want to use the scale out option we have to install the software in a Shared Network Drive, So mapped this shared network drive on the server and did the install.
Initially I didn’t map the drive I got the insufficient error:

I mapped the drive and installed the software again, initially I was unable to run the software but installed the Weblogic through command prompt:

Was able to install Weblogic, OBIEE software Install and configured. Initially was able to login to answers and tried to login em and console was unable to then figured out the “Oracle Process Manager (instance1)” is not started then tried to restart the services but the below errors came up:

Tried to restart from the location: O:\Oracle\OBIMWHome\Oracle_BI1\opmn\bin\opmn.exe
Got the below error:

My question is reinstalling going to work and did I do the followed the rite procedure for the installation.
Earlier to this tried the below two:
1) Installed OBIEE 11.1.1.5.0 on one server and tried to scale out horizontally on other machine it was good until 66 % of the configuration and waited for 3 – 4 hours but no response, then figured out that the Enterprise installation won’t work.
2) Tried to scale out the installation through Software Installation (Installed on local Drive), but came to know that the installation should be done on the shared drive.

Oracle SR

Working with Oracle on this, but they are saying that it won’t work on Shared drive requested the correct procedure but no reply as of now.

Reply

Sunil

June 23, 2011 at 3:31 pm

Hello Siva,

I am sorry the screen shots didn’t copied in the earlier post . I am writing the errors here… Please let me know if you have a solution..

Error Installing OBIEE Software Only
I am trying to install OBIEE 11g Software on Windows 2008 Server 64 bit machine, as I want to use the scale out option going with Software Install Only.
The Oracle documentation is says if we want to use the scale out option we have to install the software in a Shared Network Drive, So mapped this shared network drive on the server and did the install.
Initially I didn’t map the drive I got the insufficient error:

Error: Insufficient disk space! The installer requires:
203 MB for the middlewarehome at so and so….

I mapped the drive and installed the software again, initially I was unable to run the software but installed the Weblogic through command prompt:

in the command prompt on the drive ran this : java -Xmx1024M -Dspace.detection=false -jar wls1035_generic.jar

Was able to install Weblogic, OBIEE software Install and configured. Initially was able to login to answers and tried to login em and console was unable to then figured out the “Oracle Process Manager (instance1)” is not started then tried to restart the services but the below errors came up:

Error: Windows could not start the Oracle Process Manager (instance1) service on Local Computer,
Error2: The system cannot find the file specified.

Tried to restart from the location: O:\Oracle\OBIMWHome\Oracle_BI1\opmn\bin\opmn.exe
Got the below error:

My question is reinstalling going to work and did I do the followed the rite procedure for the installation.
Earlier to this tried the below two:
1) Installed OBIEE 11.1.1.5.0 on one server and tried to scale out horizontally on other machine it was good until 66 % of the configuration and waited for 3 – 4 hours but no response, then figured out that the Enterprise installation won’t work.
2) Tried to scale out the installation through Software Installation (Installed on local Drive), but came to know that the installation should be done on the shared drive.

Oracle SR

Working with Oracle on this, but they are saying that it won’t work on Shared drive requested the correct procedure but no reply as of now.

Reply

lavanya

June 30, 2011 at 4:35 pm

hi
I am lavanya and i am preparing for a interiview in obiee as a obiee consultant
i want to know if u have 20 reports in the dashboard and the user want to see only 10 reports in the dashboard then how to hide those reports .
thank you
lavanya

Reply

chaitantya

July 7, 2016 at 9:00 am

you can use view selector option there you can select which report you want to see

Reply

yogi

July 1, 2011 at 2:18 pm

my question here is.

i want display a dashboard with empty report initially but my condition is it shows prompts without intial values in the prompts when ever i hit the go button it display report during this process i didnt enter any values to the prompt.

is it possible in obiee to display dash board as empty?

Reply

Rajkiran Taraka

July 11, 2011 at 4:50 pm

Hello Siva,
I am using agents for seeding the cache, I am unable to view the hidden dashboard or dashboard pages. Do you have any suggestions for scheduling a hidden dashboard page.

Thanks,
Kiran.

Reply

Venu Madhav

July 16, 2011 at 6:04 am

Hi Shiva,

Could you please help me in removing vertical line in graphs(X-axis line or border). I can able to customize the grid line but not X-axis.

Thanks & Regards.,
Venu Madhav

Reply

Diniz

July 23, 2011 at 9:35 pm

Hello Shiva,

I’m having problems in generating a line-bar graph. I’m working with Essbase as the data source and want to pick the following layout:

Real and estimated (bar) – Scenario Dimension;
Percentage change (%) (Line) – Scenario dimension

The problem is everyone is on the same level of hierarchy. I have created a calculated field, but without success.

Any suggestions?

thanks

Reply

khajisai

July 28, 2011 at 4:31 pm

Hi Shiva,

Can we pass a presentation variable value from one report to other report using go url.

Thanks,
Sai Prasad

Reply

Cristina

August 4, 2011 at 3:26 pm

Hello,

I have a table TAGS with Demo_ID and TAGS and in this moment it looks like this:
1 a
1 b
1 c
2 e
2 d

And I want to make a new logical column (this is my idea) in TAGS table which could give me this result:
1 a,b,c
2 e,d

How can I do that? Should I create an expression in the new logical column? What do you suggest? Hoe should look the expression?

Thanks,
Cristina

Reply

AP

August 5, 2011 at 1:35 pm

Hi Shiva/anyone else,

I have configured the “act-as” function in OBIEE 10.1.3.4.1 and from the drop down list I am ok ti act for some users but for some the following error appears (and I am looged out of Answers):

Unable to Log In
Odbc driver returned an error (SQLDriverConnectW).

Error Details
Error Codes: OPR4ONWY:U9IM8TAC
State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004]
[nQSError: 10018] Access for the requested connection is refused.
[nQSError: 13023] An external user ‘A33369’ can not run as an internal user ‘K2824’. (08004)

Any ideas why this error comes for some users and what I need to do to mitigate? I have checked the proxy users table in the DW and there is a row for A33369 and K2824.

All help is appreciated!!!

Many thanks.

Reply

Nir

August 10, 2011 at 6:45 am

Even in short reports (at least I think they are – it works fine in OBIEE 10),
I keep getting ‘Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.’

Error Codes: IRVLJWTA:OI2DL65P
Location: saw.views.dashboard, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads
SQL Issued: 730784~jk0irse6jr4hl656pqlrv36h46

I already configured my instanceconfig.xml as follows:

500000

75

10000

false
3000
1500
50

1000
30

500000
500000

2000
1000
2000
25
6144

75

10000
1500
50

100000
&nbs! p; 1000
30

2048
16

Can you please advise?
Maybe add general post regarding all those instanceconfig parameters – their meaning and the range of acceptable values, what are there Max limits and what are the pitfalls.

Thanks a lot,
Nir

Reply

Amna

August 10, 2011 at 10:31 am

Hi Shiva,

I’m a beginner with OBIEE Answers and I have a question as follow:

I’m working on a report that has a column field that is calculated to depend on the previous row i ascending order, to elaborate more: I have columns as follow (Month, Open_old, Opened, Closed, Still_open) for ‘opened’ are complaints opened in the same month, some of them are ‘Closed’, some stay ‘Still_open’ which equals (Opened-Closed). for the first month ‘Open_old’=0, but whatever ‘Still_open’ is carried over to the next month to be in ‘Open_old’, where ‘Still_open’ will equal (Open_old+Opened-Closed).
From source i have (Month, Opened, Closed), how can I add the remaining two columns and their calculations (Open_old, Still_open).

I hope my case is clear.

I really appreciate your help.

thanks & Best Regards,

Amna

Reply

Henrique Silva

August 14, 2011 at 10:07 pm

Hi Shiva

I wonder if you have already found out how to allow users to change theis own passwords on OBIEE 11.1.1.5 right on their account dialog box. In version 10g, I got that by changing the “customMessage.xml” file, wich doesn’t work on version 11g. Hope you could shed some light on this matter.

Thanks!

Reply

Vinay

August 22, 2011 at 9:18 am

Hi,
This is Vinay.I am new to OBIEE.i have a requirement to show the page nos at the end of a report page(by default)
Suppose if i go to second page of the report is should show 2,third page of the report it should show 3.

1.I have already tried it by using pivot table option by setting the no of records and using the maxrowcountfn but I am getting it as a drop down list.

2.Can we acheive it by using the footer option in edit dashboard page.I have tried this one also but not getting it

Please help me to resolve it

Thanks,
Vinay

Reply

sanjeev yadav

August 26, 2011 at 7:03 pm

Hi shiva,
My requirement is like. Through Presentation variable m passing fiscal period(eg : 2011 P03 , P03 is march month ) to Parent report displaying YTD Actuals(measure eg abc) ,when i drill down to YTD value , i see new child report that shd display break up of YTD value(abc = a + b +c ) date wise , n that date shd be(eg : =P01 of that year, )

Plz suggest .

sanjeev

Reply

elopezch

August 29, 2011 at 3:08 pm

Hi Shiva,

I have installed OBIEE 11g, I posted on the Internet through a weblogic server, when accessed from any pc, it looks good and I can enter everything, but when accessed from an iPhone or iPad or any mobile device, the tabs that I did in the dashboard are not shown anywhere on the screen, only I get information from the first tab and the rest are not shown. What could it be?

Please help me to resolve it,

Thanks

Erick

Reply

Surya Sanush

August 30, 2011 at 9:35 am

Hi All,

I’m new to OBIEE. Actually we have a requirement like we have to display the values entered by the user in the prompt , at the top of the answers report.
For eg: If the user enters the “Name” as “x” and “Number” as “1” in the prompt, at the top of answers report, is should be displayed as Name : x ,and in next line , Number : 1.
And I was able to do this by creating a presentation variable for my prompts and calling that variables in the narrative view.

But the problem is my user enters atleast 10 fields like no, name etc. So how can i have 10 narrative views. Is there anyother way of making this possible?

can anyone guide me in this?

Thanks,
Surya

Reply

Taimoor

September 2, 2011 at 6:45 am

Hi,
I’ve a requirement to add a budget column in a P&L report of OBIA apps. I need your help of how to do it?

Reply

Kausik

September 5, 2011 at 8:25 am

I need to transfer a report into a folder. I used a VB script for geeting it done. But some error is popping up:

[nQSError: 66003] Script engine does not support the IActiveScriptParse interface.

Mines a 64 bit server. I heard there is patch for it. But am unable to locate the patch.

Plz help

Reply

Attitude01

September 19, 2011 at 11:50 am

Hi Shiva,

Recently we are facing an issue in our BI application . We have implemented Disconnected Application Cache via ibots in our application . We have used preprocessed sync and according to the process what it does is , it saves the data in .csv files into server by making folders of disconnected users.

Currently , we fould and issue that particular report does not contain data in disconnected mode. Whne we backtraced the issue we found that , the underlying table for the report is empty and when we further investigate we found that , the .csv file kept in server against Uset folder contains an error code , which is :

4TS
For this reason no data is there in csv files and the disconnected report is also showing emmpty columns for that.

Can anybody please help me solving this issue . I am not sure why this error happens and what this kind of error code signifies.

As it is a production issue, it becomes very urgent to solve this . Can anybody please give me some idea how to resolve this one.

Thanks and Regards,
TG

Reply

mohan

September 21, 2011 at 11:44 am

Hi shiva,

This is mohan,
1.how do get last week sales. I need a sql query
2. what is a brige table?
3. how do implement report level security?
4. i face a challenge that is in rank/ top functions i didnt get total sum how do i get aggregation sum for rank/ top functions?

please send reply
thanks.

Reply

Jayanth

September 21, 2011 at 6:18 pm

Hi Shiva, I have a requirement.

We have Opportunities and Activities. And the relation is 1:M

Lets suppose that we have Opty1 and 5 activities Act1, Act2, Act3, Act4, Act5, I can identify these Acitivities uniquly under each Opty using the Activity Type. So lets assume that for all the 5 Activiites there are Types like A1–> T1, A2–> T2, …. A5–> T5. Also each activity has Start Date and Date.

Now I have to pick those opportunities which have 2 activites A1 and A2, and End Date of A1 should be <= startdate of A2

I am struggling with this. Please provide me incase you have any idea.

Reply

teja

September 23, 2011 at 7:13 am

hi ,
I want to display the number of page in a dashboard page and also the date for the report .

Reply

Dinesh

September 26, 2011 at 11:27 pm

Hi

I have two requirements in OBIEE Reports can you please help me to resolve the below two issues that i am facing in my Reports

1) Running Avg : In one Report i have to report running Avg based on the number of the records displayed in my tabular form . eg… i have 4 rows .. sum of all the rows is 100.. then my avg should display 25 .. while based on the report prompt selection if i get 6 rows .. and sum is 120.. then avg should be 120/ 6 : – 20 . This Avg is calculated at the run time .. I am displaying this avg value as another report on the top of the same Dashboard.. Now ..my problem is i am not able to get this dynamic running Avg value.. I only get one Avg value at Grand Total Level.. which is not correct ..
can you please help .. if there is any way i can achieve this running avg ?

2) Graph Data and Tabular Data are not in sync – I am restricting the number of rows to display at given point of time to say 15 .. per page in tabular form.. But the graph that i build on top of the Tabular Data is showing all results based on the report selection . I want to make sure the Graph and my tabular data are sync .. e.g if my rows are 15 .. the graph should also for 15 records and when i do next page .. the tabular data will get next set of 15 records and similarly my graph now should reflect the new 15 records .. Can you please how to achieve this ?

Appreciate any pointers to resolve these two report issues

Thanks,
Dinesh

Reply

Deeptha

September 28, 2011 at 6:06 am

Hello,
I have 2 fields in my table, one contains one ore more codes delimited by pipe or comma and the other field contains an integer. I want to separate the field values with delimiter and consider it for summing up the integers. I do not want to use Derived Dimensions since if there are more codes added, then there is lot of rework to be done.

Eg:
ColA ColB
Code1, Code2 5
Code1, Code3 10
Code2 2
Code3 3

The Result I want to display is as below:
Code1 = 15 (as sum of row 1 & 2 for the ColB)
Code2 = 7 (as sum of row 1 & 3 for the ColB)
Code3 = 13 (as sum of row 1 & 4 for the ColB)

Is this possible in OBIEE Dashboard?

Thanks,

Reply

venkat

September 28, 2011 at 10:38 am

Assistance needed please

hello people, this is venkat i am facing few problems in installing OBIEE(10g 10.1.3.4) and its database oracle 10g. I’ve installed OBIEE 10.1.3.4 and it also has a setup of Oracle database 10g, and i even tried to install that as well. after successfully installing OBIEE, and i even tried to install the orale database 10g…at the end of the installation, a small window popped out saying ‘password management’ i’ve unchecked SH, HR and SCOTT.

When i started with my first report, I couldn’t any SH(Sales History) folder to choose this as my source in building a report in the presentation layer. can anyone please help me out in this regard.

regards
venkat

Reply

Gotzon Barrueta

September 29, 2011 at 11:26 am

Hello,

I have a problem with a dashboard month prompt in OBIEE 10
If I use month ( the number: 1,2,3… ) it works, but if I use monthname ( the text: Jan, Feb… ) it doesn´t work.

Can you help me please ?

Thank you very much.

Gotzon.

Reply

JL

September 29, 2011 at 6:46 pm

When displaying data in a horizontal bar graph, it is possible to force every label of the vertical axis to be shown. Right now it shows one, skips one, etc.

Reply

nag

October 3, 2011 at 5:13 am

Hi any body,,

can you give me reply for below questions..

Can we create promts on measures?

will we apply prompts to chart tables, pivot tables?

what is difference between hidden and excluded?

how do we set up refresh dashboard for every one hour?

CAN WE APPLY COLUMN PROMPT ON DASHBOARD?

what is is prompted?

thanks
Nag

Reply

Rafi

October 5, 2011 at 12:39 pm

Hi Shiva,

I have created YTD, QTD and MTD logical columns at RPD level which is working but the problem which i am facing is that the Figures which i am getting through YTD, QTD and MTD is not matching with the actual figures. i have a fact table called sales fact which has transactional data and i have created hierarchy as

calendar
Total Year
Year
Quarter
Month
Day

The day is the lowest level in my hierarchy.

Waiting for your reply.

Thank you.

Reply

Arun Prasad M

October 10, 2011 at 2:29 am

Hi Shiva,
Am new to OBI Development.My requirement is to query a database from where i would get criteria’s for report execution like execution time, the search conditions the email template to be used sender and receiver email addresses, etc based on which i will be querying another database to fetch the actual data to be sent as a report. Can you please let me know how to get started and proceed with this?

Reply

srikanth

October 10, 2011 at 2:30 pm

hii shiva
can i navigate from one hierarchy to another hierachy in bmm layer
if not why canoot we do it and solution please;

Reply

Deepika Sinha

October 11, 2011 at 1:42 pm

Hello,

we have table from t1 to t8 and all join are in following format

we have scenario like t1 join t2 ,t2 join t3, t3 join t4 , t4 join t5 ,now t6 join t5 , t7 join t6 , t8 join t7.

and we have to show reports using t1 and t2 table mostly. so how we design our bmm layer using above scenario that data which we get from UI level should always correct.

Note- In Physical layer database source is OLTP database and t1 join t2 means t1 at 1 and t2 at Many side

Thanks
Deepika

Reply

Santos

October 12, 2011 at 4:15 pm

I am facing an issue with Line Time Series Graph.

Dayname (Tue, Wed, etc..) is always showing a day in-advance whereas the pointer on the graph shows correct date/timestamp.
The filter I am using is LAST_UPDATE_DATE > TIMESTAMPADD(SQL_TSI_DAY, -2, NOW()).

Any idea?

Thanks,
Santosh

Reply

John Hollifield

October 18, 2011 at 8:25 am

Hi Shiva,

We have a problem with the OBIEE 11g (running 11.1.1.5) Action Framework and wondered if you had seen similar or maybe point me in the right direction of a solution.

I am logged into OBIEE as a user with permissions to create actions but when I click New->Action (from the top dropdown menu or anywhere else) I get a server error which states:

An error occured during processing of the SSL protocol
1093359936:error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed:s3_clnt.c:1059

The log viewer in Enterprise Manager gives us

UNKNOWN_CA alert received from [HOSTNAME] – [IPADDRESS]. The peer is rejecting the certificate chain as being untrusted or incomplete.

We are running SSL everywhere and everything else seems happy with our certificate. I have dug into the documentation with no success. Any help would be appreciated.

John

Reply

Neela

October 19, 2011 at 5:48 pm

Hi Shiva,

Great to see ur post…I need ur help for some of my questions..I also have been working on OBIEE for the past 3 years and also I have worked on OWB to an extent…I have completed my Oracle Certification in OBIEE 10 g as well…I just want to improve my BI career graph…Is there any other possible certifications that you can suggest me or how should I move forth ?

Reply

Giri

October 29, 2011 at 8:18 pm

Hi Shiva,

How to remove the “powered by oracle” logo which appears at the bottom of the dashboard in Siebel Answers in OBIEE 11.1.1.5.

Generally in 10g we followed below way.

1. Open OracleBI\web\msgdb\l_en\messages\productmessages.xml file.
2. Search for the fmap:siebelbug.gif line on this file
3. Replace it for fmap:empty.gif and save it.
4. Restart Oracle BI Server and Oracle BI Presentation Server Services in order to apply this changes. Or if you are already logged in the application, prior to stop and start both services, you can click on Settings > Administration. On the Administration window opened, click on Reload Files and Metadata. Wait a few seconds, then go back and access the Download Link. The changes will be applied there.

Regards,
Giri

Reply

sathish

November 3, 2011 at 11:02 am

Hi shiva,

My reporting scenario is i want to show employees who are all to claim the their travel claims together.In Claim_emp is table,there are emp_no,emp_name.from_city,to_city all columns, in which some employees are (travel together so their departure and destination are the same) claim their travel allowance.I want to show employees who are all claim together(claim no is unique to every emp but departure and destination are the same) in reports level in answers.

Reply

David

November 3, 2011 at 7:03 pm

When I connect via VPN to my clients network then log into their OBIEE 10g implementation, I am not able to do certain things like open or save a report, the IE symbol just ‘spins’. When I drag columns in and choose ‘results’ the IE symbol just spins and nothing happens. I have had the client try this while logged on with my ID at their site and it works fine. What do you think could be the cause?

Reply

Aakarsh Kalra

November 4, 2011 at 8:44 pm

Hello,

We are using BI Publisher 11g and have a requirement of showing the usage statistics of the different reports in BI Publisher 11g. I have seen the video in the blog which shows what all we can do with usage statistics but i would really appreciate if someone could explain me the steps or give me pointers on how to get the usage data. In which tables does it reside, the column names, any other help on this will be greatly appreciated.

Regards,
Aakarsh

Reply

MadhuSudhan

November 6, 2011 at 6:32 am

Hi Shiva,
i ve a requirement in dash board i want to display results certain condition how can we achieve this requirement plz …..
Thanks
Madhu

Reply

George

November 6, 2011 at 10:14 pm

How does OBIEE deal with non-aggregate measures, for example, inventory End on Hand?

Thanks
George

Reply

Venky

November 13, 2011 at 1:37 pm

I have OBIEE report with 10 columns and I wanted to compare 3 columns data like

col1 col2 col3
ab 01/31/2011 125.00
ab 01/31/2011 125.00
xy 01/25/2011 150.00

similar to the above example I am getting some repeated data for those 3 columns in some periods. So my question is how can I create a flag or highlight data where ever we wee duplicate of these 3 columns. Please suggest me how to do this in OBIEE Answers

Reply

Ashish

November 16, 2011 at 3:21 pm

Hi,

we have OBIA 7.9.6.3 with OBIEE 11.1.1.5 in place on Oracle Studio based in US.

Dashboards/reports are picking up date in US format (MM/DD/YYYY) even I have altered file localedefinitions.xml with locale “en” , “en-us” or “en-GB”. I need to format using DD-MON-YYYY which I can do from dahsboards but there a lot to change. Is there any easy way to do that through any other config file?

Regards,
Ashish Gandhi

Reply

Carol

November 16, 2011 at 7:48 pm

Hello, how are you?
So, can you help me, pls?
I need create a report with 2 selector views, each selector view need show with different scenario. All the crossing is the same for two, except the scenario.
I created, but its return duplicated.
Do you know why?
If you didnt understand me, ask pls, because my english is so-so.
Thanks!

Reply

Warren Treuhaft

November 22, 2011 at 2:25 pm

We are experiencing differences in the results generated by P6 Analytics & Primavera. A basic report showing actual hours charged by resources against an activity are different between Analytics & what we see in Primavera and are not related to timing issues for updating the cubes, etc.

Reply

sahadev

November 24, 2011 at 10:03 am

Hi shiva,
I have the requirement on answers in obiee, which is having sum values on Y-axis, and time frames like ’00-12h’ on the X-axis. My doubt is i want to display my chart with sum value bars on the Y-axis but i don’t need sum value scale, i want to display the scale as percentage values like, ‘0, 2.5, 5.0, etc . Can you please give the proper way solution for this.

Thanks,

Reply

Srinivas.

November 25, 2011 at 5:53 am

Hi Ashok,
I wrote a formula below for a column in answers where the case statement includes columns from two different objects fact and column.
CASE WHEN “Fact”.”COL1″ = ‘VALUE1’ THEN ‘RESULT1’
WHEN “Dim”.”COL2″ = ‘RESULT2’
ELSE ‘RESULT3’ END
However the query being generated by obiee server is incorrect. Please see the group by being generated. Please advise why the case statement in not being included in the group by?

group by Fact.”COL1″, DIM.”COL2.”

Thanks in advance
Srinivas.

Reply

Madhu

November 28, 2011 at 4:19 pm

Hi Shiva,
I’m having a weird situation. I’m working in OBIEE 11g.
A new analysis (inline) created with a prompted variable and referenced this presentation variable from the variable prompt in title of Analysis.
When ran the Analysis, we see actual value of the prompt what we enter on the first page for the prompt of title. When tried to see next 25 rows or all rest of the rows, the presentation value is reset and we see @{variable_name}. We intended to see the value not the actual literal @{variable_name}.

We have had similar results using this Presentation Variable in filters, columns, etc. It works fine for the first 25 rows, and then the Presentation Variable appears to be reset.
We are able to successfully use Presentation Variables that are set through a Dashboard Prompt, but not those that are embedded in an Analysis.

Any help, I’ll grately appreciate you.

Thanks,
Madhu

Reply

manisha

November 29, 2011 at 8:10 am

Hello,
Am new to Obiee.
I need to know how do i check if the services for obiee 11 g is running?
What services do i need to start?
Actually i type the url for obiee 11g and it does not work, how do I debug?

Regards,
Manisha

Reply

chaitantya

July 7, 2016 at 9:03 am

see the status in services that means opmnctl services is enabled or not

Reply

Devang

November 30, 2011 at 3:56 pm

Do you have a steps for setting up the usage tracking in OBIEE 11g?

Reply

Ashish Gandhi

December 1, 2011 at 12:45 pm

Usage Tracking :
1. Created 3 tables in DWH (You should find DBScripts in Sample folder under 11G)
2. Seed data for 2 tables in DWH (You should find DBScripts in Sample folder under 11G)
3. RPD Updates :
a. import S_NQ_ACCT, rename current tables – S_NQ_ACCT to S_NQ_ACCT_OLD – Existing physical table S_NQ_ACCT does not work during INSERT.
b. Used utility to replace table in logical table so that it will refer to S_NQ_ACCT
c. Altered physical diagram – link with new table S_NQ_ACCT
d. Altered tables for rest of the ALIAS to point to S_NQ_ACCT
e. Altered select Query for S_NQ_USER_GROUP – Select distinct USER_NAME Login, USER_NAME Resp from S_NQ_ACCT; (Caveat – This needs to be linked with users/security but we are not there yet)

4. Update NQSConfig.ini file for 2 entries (As per documentations for data base INSERT) –
5. I am Struggling to get OOB Dashboards/Reports from Sample folder – When unzipped and opened using catalog manager – I was getting ERROR. Also tried and copying report folder from usage tracking but not able to see it in the catalog from Web.

Reply

Ritesh

December 2, 2011 at 3:37 am

Hi Shiva,

Do you have the steps to change the default colors of a bar graph in obiee.I had seen a blog regarding this a few months back but i dont see it anymore

Thanks

Reply

surya

December 4, 2011 at 4:30 am

HI i have a requirment i have a report with 60+1 columns. that 1 column has some values say countries in another 60 columns y or N. whenever i select perticular country name from the prompt if some columns hass all N or null values i want to hide those columns which ever has Y. i want to display only those columns in the report

Reply

Mihai

December 6, 2011 at 10:14 am

Hi,

In OBIEE 11g I have an analysis based on another analysis which uses request variables (SET VARIABLE DISABLE_CACHE_SEED=1, DISABLE_CACHE_HIT=1;). When I try to run it, I get the error “Unresolved table: SET “, because the logical query is made this way:

“…IN (SELECT saw_2 FROM (SET VARIABLE…”

Is there any way to fix this?

Thanks!

Reply

siri

December 8, 2011 at 11:47 am

Hello Guys,

I have implemented a ber graph for a figure with 100% in sharepoint designer using xsl.Bar chart should not be displayed ,if the value of the figure is null,and if ‘0’,bar chart colour with light shade.So I am trying to make it with ,but no result.
Any idea?

Reply

Prashanth

December 13, 2011 at 7:04 am

When i try to cast a column(date) as timestamp. I get this error

“[nQSError: 22025] Function Cast is called with an incompatible type”

my query looks like this….. CAST (column_name AS TIMESTAMP)

Reply

Kbklumar

December 13, 2011 at 11:26 am

Hi Shiva,

I have one plant wise summery report, I added this report in dashboard page. Now I want when I click on particular plant in summery report the detail report should come under summery report in same dashboard page. I tried but it’s going next page.
Please help me how can I achieve this requirement, It’s urgent.

Regards,
Kbkumar

Reply

Prakash

December 13, 2011 at 11:48 am

how to retrive null dimension column from another report.
Example:
I want to pull one null Company name from another request.
One request contains ranking of top 50 company name for some sale fact value.
including null column .
Second request will pick these top 50 company name on the basis of rank.

Reply

Bharani Kumar

December 14, 2011 at 5:16 am

Hi Shiva,

I have one requirment,I have one plant wise summery report, I added this report in dashboard page. Now I want when I click on particular plant in summery report the detail report should come under summery report in same dashboard page. I tried but it’s going next page.
Please help me how can I achieve this requirement, It’s urgent.

Regards,
Kbkumar

Reply

Sri

December 15, 2011 at 5:14 pm

Hi, I have a requirement with a report prompt, ‘Month Range’ having a between operation in a format like ‘YYYY-MM’ eg values(2011-12,2011-11, 2011-10,etc..). now the validation required is that when ever user select a value say ‘2011-11’ (which can be a start date) and ‘2011-12’ (which can be a End Date as we are using between operation) then it should prompt (i.e) —[End date < start date] from being selected…

Reply

roopesh

December 18, 2011 at 10:28 am

Hi Shiva,

Thanks for sharing Ur knowledge on obiee.

I have one requirement in reporting. one report has to show these columns
totol no. of retails
no. of retail outlets with loss above 50% and 3 months
no. of retail outlets with loss above 50% and 4-7 months.. etc

for no. of retail outlets with loss above 50% and 3 months i used filter
filter(total no. of retails using loss>=50)
here total no. of retails is aggregation count
i need to add another condition here to check and fulfill the loss of retails above 3 months with 50%

i am doing this in rpd.

Reply

ananth

December 19, 2011 at 6:44 am

Hi

Shiva

plz let me know some drawbacks of time series related to cache……

Thank

Reply

Ruchi

December 19, 2011 at 2:53 pm

Hi, I have one client requirement that I have to add a Column in obiee 11g report, whose value should be pdf icon and we click on that icon it should open that saved pdf. Can u plz rply me as soon as possible.

Reply

Ruchi

December 19, 2011 at 2:54 pm

Hi, I have one client requirement that I have to add a Column in obiee 11g report, whose value should be pdf icon and we click on that icon it should open that saved pdf. Can u plz rply me as soon as possible.

Reply

ruchi

December 19, 2011 at 2:56 pm

can we add a column in obiee 11g report whose value should be pdf icon and we click on that it should go that saved pdf.

Reply

Javier

December 20, 2011 at 12:33 pm

Hi
I’m using the Narrative view to print out whatever the business user has chosen in the prompts. Now I have a prompt with multi selection, say stores. If the business user for some reason or another chooses 25 stores, I don’t want the Narrative view to print out all 25 stores, it could type out something like “You’ve selected more than 3 stores” … Or “You selected 25 stores” or something like that. I’ve been trying with Presentation Variables, COUNT(DISTINCT and son on but it works only on the Analysis. When I use the dashboard prompt and send, say 25 items it gives me and error, SQL statement error.
How can I do this?

Reply

sathish

December 20, 2011 at 1:06 pm

Hi, i have a requirement i have three prompts in dashboard with year,quarter,month.If i select Q1 in month prompt it is showing jan,feb,mar….but my requirement is if i select Q1, in month prompt it has to show july,august,september..pls help me out of this.

Reply

Lavanya

December 21, 2011 at 2:03 pm

Hi Shiva,
I have one drill down for one a manager column in one report. If I click on manager’s name, it should should show current and historical reportee,but it is showing historical and current.How can I control the order. I am using pivot view for report. If I create table view, the display is fine.

Reply

prabhu

December 22, 2011 at 12:02 pm

hi siva
how to implement external table aurhenticarion in 11g

Reply

Jayashree

December 22, 2011 at 2:49 pm

Hi Shiva, I started working on Oracle Apps OBIEE application. I dont see PO Headers item description in the Physical Layer. How to bring it? Please guide.

Also please send me your email id so that I can send you the screen shots of the errors i am getting. Thanks in advance

Reply

Santhosh

December 28, 2011 at 9:37 pm

Hi,

I have a question on ODI 11g. I wanted to set up external user authentication/single sign on in ODI. I found OBE online but did not understand it clearly.

Please let me know if you have any idea on this.

Thanks,
Sanhosh

Reply

Ayyappan

January 5, 2012 at 7:52 pm

Hi shiva can u Please give me the steps for enable Proxy functionality in OBIEE 11.1.1.5 …

When i following step in many URL for enabling Proxy functionality in 10g its showing error as
This functionality has not been enabled by your administrator…So please help me…
I put the xml file in the following path C:\Obi\instances\instance3\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\msgdb\l_xx\customMessages

Please help me

Reply

Ayyappan

January 5, 2012 at 7:52 pm

This is my xml file

EXECUTE PHYSICAL CONNECTION POOL Act_As_Users.CP_Act_As_Users select target_Id from OBIEE_ACT_AS_USERS where proxy_Id=’@{USERID}’
EXECUTE PHYSICAL CONNECTION POOL Act_As_Users.CP_Act_As_Users select target_Id from OBIEE_ACT_AS_USERS where proxy_Id =’@{USERID}’ and target_Id=’@{VALUE}’
EXECUTE PHYSICAL CONNECTION POOL
Act_As_Users.CP_Act_As_Users select proxy_Id, proxy_Level from OBIEE_ACT_AS_USERS where target_Id =’@{USERID}’

Reply

Deepak Karanwal

January 5, 2012 at 9:03 pm

We have 200 different version of same report(difference is in their filters) and our users want to schedule these report to run once a week. So we created a report with 200 ibots and asked user to subscribe these ibots and customise their subsciption with there specific promts. So when these Ibot runs users get different vesion of results based on their customisation of prompts. And also we will be saving the file in filesystem via javascript.

Issue is that when Ibot ran , user get their verion of result in thie email but the file which get saved on server does not filtered on the user customisation of subsciption. Basically it ran the report while ignoring the filters which user provided in the subsciption.

For eg a report which has say two columns
Fiscal Year Amount

filter: Fiscal Year is prompted

So we created an ibot and asked user 1 and user 2 to subscibe it. User1 subscibe it and customise it to run for 2011
and user 2 subscibe it and customise it to run for 2012. What happened that in their email or dashboard they see data for 2011 and 2012 respectfully but on the filesystem on server thhe saved filed (Job_id_user1_filename.xls) and Job_id_user2_filename.xls) had values for all years and they are same , they donot filter the data based on their subsciptions.

Reply

Gauranga

January 5, 2012 at 10:29 pm

Hello Shiva,

Could you please explain the difference between Column Prompt and Variable Prompt?

Thanks,
Gauranga

Reply

VB

January 6, 2012 at 11:03 pm

Has anyone found a work around for Line/Bar stacked Chart issue on OBIEE 11g?
I’m trying to do a chart with Both Bars and Lines are stacked.

Requirement:
Revenue and Qty Fields as measures
Product as the Dim

I want bars to be stacked Vertically for revenue and Lines to be stacked for Qty.
I tried chart on the pivot view which works fine on 10g. Bars stack fine, the problem I see on 11g is line scale marker doesn’t not stack right.

Please try this..
Let me know if anyone is successful Thank you..

Reply

Santy

January 20, 2012 at 10:46 am

Hello Shiva,

Could you please throw some light on hw can I build presentation layer based on two different RPDs built on seperate data sources? Lets say I have one RPD based on Oracle EBS transaction system for actuals, and other RPD based on Hyperian planning system puting data Essabase cube regarding budgeted values. Now I want to build one report for variance analysis to show actual vs budget values. To build such report using analyses, can I have two rpds combined or join them. If Yes, then Hw can I do that, IF no then wht should be my deign approch.?

Reply

Chris

January 24, 2012 at 8:31 pm

Shiva,

I have a business requirement where I need to publish a set of columns and a duplicate set of columns for comparison. The first set are from a fact table where the results are constrainted to a specific customer. The second set are from the same fact table, but the results are supposed to span all customers.

For example, here is the data in the database:

CustID Cost
=================
1 5.00
2 7.00
3 8.00

When a user logs into OBIEE only having access to CustID 3, they should see the following when comparing CustID 3 to all Customers:

CustID Cost CostForAll
============================
3 8.00 20.00

How would you model that in the business layer?

Thank you,

Chris

Reply

kumar

February 7, 2012 at 5:32 am

Hi shiva,
can you help me out from this…
I hav a month prompt and it displays only last 6 months values from current date.
ex:month:1,2,3,4,5,6,….,12
It has to be displayed only six values in a prompt.

Thanks in advance…!

Reply

Rohit

February 7, 2012 at 10:53 pm

Hello Shiva,

I wanted to ask a question. Is it possible to apply separate filters on separate columns with a single report? If yes, how?……I have a column containing multiple values and there is corresponding amount associated with it. In my report i have to display “the multiple values” in separate column and corresponding amount in front of it.

This is a sample table in the database along with other columns
Col A Col B
20 W
30 X
40 Y
50 Y
60 X
70 W
80 Z
90 R
110 R
65 X

So in my report it should be displayed like (along with other columns). I need filters which perform such a function without harming other columns.

W X Y Z R
20 30 40 80 90
70 60 50 65 110

Is there a way where I can filter my columns like this and then include in the report? So that other columns are not affected by the filter.

Reply

Rakesh

February 8, 2012 at 11:01 pm

Obiee 10g delivers cannot connect to smtp server
i have chosen GMX in the job manager scheduler mail tab
sender address rakeshgopidi@gmx.com
smtp server mail.gmx.com
smtp port 25
username rakeshgopidi@gmx.com
pswrd:xxxxxxxx

in the answers delivery options devices i added email device rakeshgopidi@gmail.com…
what actually is wrong please help me am wasting lot of time on it

note: am using for practice purpose not in real time scenario on laptop
when i checked my log files in ibots folder

+++ ThreadID: 2bf8 : 2012-02-07 14:10:42.875
iBotID: /users/administrator/_ibots/
rbot/rbot 2012
[nQSError: 75003] Failed to open connection to SMTP Server.

+++ ThreadID: 2bf8 : 2012-02-07 14:10:42.877
iBotID: /users/administrator/_ibots/rbot/rbot 2012
…Trying SMTP Delivery loop again

+++ ThreadID: 2bf8 : 2012-02-07 14:10:42.879
… Sleeping for 5 seconds.

+++ ThreadID: 2bf8 : 2012-02-07 14:12:11.951
iBotID: /users/administrator/_ibots/rbot/rbot 2012
[nQSError: 75003] Failed to open connection to SMTP Server.

+++ ThreadID: 2bf8 : 2012-02-07 14:12:11.953
iBotID: /users/administrator/_ibots/rbot/rbot 2012
…Trying SMTP Delivery loop again

+++ ThreadID: 2bf8 : 2012-02-07 14:12:11.955
… Sleeping for 8 seconds.

+++ ThreadID: 2bf8 : 2012-02-07 14:13:44.005
iBotID: /users/administrator/_ibots/rbot/rbot 2012
[nQSError: 75003] Failed to open connection to SMTP Server.

+++ ThreadID: 2bf8 : 2012-02-07 14:13:44.007
iBotID: /users/administrator/_ibots/rbot/rbot 2012
…Trying SMTP Delivery loop again

+++ ThreadID: 2bf8 : 2012-02-07 14:13:44.008
… Sleeping for 6 seconds.

+++ ThreadID: 2bf8 : 2012-02-07 14:15:14.160
iBotID: /users/administrator/_ibots/rbot/rbot 2012
[nQSError: 75003] Failed to open connection to SMTP Server.

+++ ThreadID: 2bf8 : 2012-02-07 14:15:14.162
iBotID: /users/administrator/_ibots/rbot/rbot 2012
Exceeded number of delivery retries.

Reply

sudhakar

February 9, 2012 at 9:27 am

Hi Shiva
how to create the graph prompt in pie charts
and also how to calculate last three months in pie chart only.
could you please send some solutions

Thanks & Regards
Sudhakar

Reply

Bhupal

February 15, 2012 at 5:21 pm

Hi Shiva,

I have embedded the OBIEE components in my ADF application. All compoents except the maps are not being displayed on the jspx page.

Malformed url ‘/Application/BIProxy?cid=OBI&RedirectURL=saw.dll%2f%2fmapviewer’.

Error Details
Error Codes: YC9VC6XO
Location: saw.views.dashboard, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads

Pls help.

regards,
Bhupal

Reply

punitha

February 21, 2012 at 3:39 pm

how to delete oci.dll file please procedure

Reply

jose carlos ferreia

February 23, 2012 at 2:41 pm

I want to insert a page break in the table case the group number of rows exceed the number of rows left in the page.

So basically I do not want to split the fields of each group in different pages.

Example of what happens:

NAME Projects
John 45
Eliot 12
23
Michael 12
45
11
Peter 23
(new page)
13
12
Robert 24

As I wanted it to be:

NAME Projects
John 45
Eliot 12
23
Michael 12
45
11
(new page)
Peter 23
13
12
Robert 24

I want a solution if possible in the rtf template, I’ve already made a counter to solve this problem but isn’t the best solution

Reply

Amit Sangle

February 27, 2012 at 4:55 am

Need guidance & assistance as mentioned below –

Please go through the link – http://docs.oracle.com/cd/E21764_01/bi.1111/e10544/appuserinfo.htm#CEGIBIIB –> About Running Actions Using Action Links and Action Link Menus in Analyses and Dashboards.
We need steps, how to send mails, how do we configure action links in such a way that the diagrammatic report is sent as an mail to whoever has logged in on the analytics link.

Reply

madhu

February 28, 2012 at 4:12 pm

Hi Shiva

I havae a question, how to improve performance in obiee & How to optimize the query performance

Reply

basha

March 3, 2012 at 3:50 am

Mr.Shiva Molabanti
can u pls give me some answer for this question
what is a good deffination for dimension table

Reply

Arezou

March 5, 2012 at 10:05 pm

Hope all is well! We have been having an issue with OBIEE .5 drilling down in Time dimension. Here is the scenario:

“The hierarchy for time dimension is ” Fiscal Year—> Fiscal Quarter—> Month(Name)—>Date”. When I select a Time dimension and click results its getting opened in a Pivot table view. The problem here is, when I click the “Total” it’s getting drilled down to Year —> Quarter but when I click on “+ sign next to quarter” it should drill down to month for that particular quarter for that particular year but its drilling down to month for that particular quarter for all years.”

Is this a bug?

Reply

sashi

March 7, 2012 at 2:34 pm

Hello Shiva
How to display current_date or yesterday’s date in iBots headline in say m/d/yyyy format.
Currently I am using
@{system.currentTime}[M/D/YYYY] as part of the headline.
example : Top25 agents list for today @{system.currentTime}[M/D/YYYY]

Is there an alternate to the above? Or lets day I have a hidden field in my report containng the today’s date or yesterday’s date,.. how would i use that inside the ibot headline ?

Is it possible ?
If i have to display say yesterday’s date, or some last wk monday how to do?

thanks

Reply

mozhdeh

March 11, 2012 at 11:48 am

Hi Mr.Shiva,
can you plz tell me how can I print analysis compound layout in obiee, or how can I have a print button or somthing like this in my compound layout?
tnx

Reply

rakesh2020rakesh

March 14, 2012 at 8:39 am

obiee 11g sampleapp_10722 deployement on windows
hi i have tried to deploy sampleapp_10722 on windows but cannot proceed further i will share the source and my error also below

Click to access sampleapp107-deploymentguide-435786.pdf

and
http://sunnyobi.blogspot.com/2011/10/sampleapp107-deployment-on-windows.html?showComment=1331693157665#c94710599257082706

Import the dump file SASchemas.dmp using the following command.
impdp’sys/sysdba@orcldba as sysdba’ dir
ectory=datapumpdir dumpfile=SASchemas.dmp version=11.2.0.1.0 schemas=BISAMPLE,OB
IEE_NAVTEQ,BIFOD,BIBPM,DEV_ODI_REPO,ODI_STAGING LOGFILE=SASchemas_imp.log

Import: Release 11.2.0.1.0 – Production on Wed Mar 14 05:16:04 2012

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 536
ORA-29283: invalid file operation

am getting this error how to resolve this issue….????

Reply

Madhu

March 15, 2012 at 7:23 am

Hi Shiva,

pls help me

i have two date columns how do we find the least date in 3rd column

Reply

Vikas

March 16, 2012 at 5:53 pm

Hello Shiva,

I am looking for some guidance/steps or documentation to create the prompts (on a dashboard page) which are constraint based on a value in a “hidden prompt”.

Please share if you have idea on this.

Reply

Ram

March 20, 2012 at 6:49 pm

basha.
Dimension table definition:

A business uses facts to measure performance by well established dimensions. Every dimension has a set of descriptive attributes. Dimension tables contain attributes that describe business entities. For example, the Customers dimension can contain attributes like Region, Subregion, Country, State, Customer.

Reply

Santosh

March 21, 2012 at 8:15 am

Hi Shiva,

I have a requirements where the report need to have table of content section , sections having lot of textual paragraphs (narratives), those paragraphs will also have figures embadded comming from members of essbase cubes, will have lot of tabular information capturing the KPIs, will have various graphical representation of the same tabular information, need to have headers, footers , foot notes to be printed in the report..

Basically it is a publication/manual kind of report which need to be regularly braodcasted to the business users with updated kpis and narratives sourced from Essbase database/cube.

Is it possible to build such report in OBIE11g using analyses. How easy of difficult it is, if possible? Are there any prerequesities to build such reports in 11g analyses? I mean to ask does it need any third party component/software installed on the BI server.

My main source of information will be essbase cube where lot of narratives (text information) will be entered by the business users. KPIS will be updated from DW layer in the Essbase cube for various members.

Thanks in Advance.
Santosh

Reply

Sudhakar

April 5, 2012 at 4:02 am

Hi,

I am using obiee 11g. When I am drilling from parent report to child report it is showing me following error :

Assertion failure: isXsiTypeSqlExpression(rExpr) at line 67 of /net/stasunnas09/export/ifarm_test/solaris64/views/ aime_bifndn_936652/bifndn/analytics_web/main/proje ct/webreport/exprformulautils.cpp
Error Details
Error Codes: ACIOA5LN
give me any solutions

Reply

kalyan

April 9, 2012 at 6:26 pm

Can we create a report to list all open purchase orders that have a specified list of company codes. This report would be run on demand monthly, and the Company Codes list will change month to month. The Company Code is found at the accounting distribution level of the order. The purpose of this report is to identify any orders that may need to be revised due to their company codes being eliminated (we want to make sure no orders have an invalid company code). If possible, exclude canceled orders and fully billed orders from the resulting report.

Reply

dred

April 18, 2012 at 10:38 am

Hi Shiva,

Our requirement is to match the displayed records of the table and its chart per page. for example, i have a total of 100 records and was set to display 20 records per page. the requirement was, that the graph would also show the first 20 records initially, and if i click the next 20 records, the graph would also show the same record for the next 20.

can you please help me? thanks so much,.

Reply

Ankit Jain

May 16, 2012 at 1:28 pm

Hi Shiva

I have a requirement

I have to select a Value(Year) from the Dashboard prompt

Dashboard Prompt -> Fiscal Year (from time dimension)

When the user selects an year in the prompt, the report below should display that year and the last 5 years.

Eg. If 2010 is selected, the output of the report should contain only 2010,2009,2008,2007,2006,2005.

NOTE:the Fiscal Year column is of VARCHAR type.

In the report (Plain Table) there is only one column in criteria, ie. Fiscal year.
So when u select 2010 in prompt and click apply, the report should display the respective years

I tried the following solution but am unable to get the solution to my answer

If we pass the year selected in prompt as x

Then the new prompt will be limited based on
Fiscal year is between x and (x-5).

Unfortunately, we cant pass it a value like x-5 in the values of the prompt. I have tried passing x-5 also into a variable and the giving between x and y but still it doesn’t consider value of y properly.

Kindly Help me at the earliest.

Regards
Ankit

Reply

Deepika

May 29, 2012 at 4:21 am

u can achieve this by filter based on another query

Reply

KP

May 29, 2012 at 7:18 pm

Hi Shiva

I have created a logical column ‘Previous Service Date’ in RPD using the below function. Consistency check is okay. But when I use the column in answers, it thro the error ” Unable to navigate requested expression: Previous Service Date :[Daggr…)
Please fix the metadata consistency warnings”

Please let me know where I am doing the mistake.

EVALUATE_AGGR(‘LAG(%1,1) OVER (PARTITION BY %2 ORDER BY %2,%1)’ AS DATE , “Dim_W_DAY_D_Service_Date”.”DAY_DT”, “Dim_X_SRV_INSTALL_BASE_D”.”INSTANCE_NUM”)

Reply

nandha

June 24, 2012 at 3:10 pm

Check for the content level and set the content level in the LTS

Reply

Esha

June 4, 2012 at 10:01 pm

Hi Shiva,

I have a requirement , where i need to show grand totals based on the selected values of hierarchical column(prompt), i tried using selection steps but not getting proper results, it was taking only values that are selected during the selection steps not overriding values with prompt while summing up.

Any help is appreciated.

Thanks,

Reply

raju

June 7, 2012 at 6:42 am

i alias table hit the database or not? how it works in obiee.

Reply

raju

June 7, 2012 at 6:43 am

is alias table hit the database or not? how it works in obiee.

Reply

Toby

June 22, 2012 at 3:02 pm

Hi Mr. Molabanti,

My name is Toby, and I’m with the United Nations. Would you be willing to advise me on some OBIEE related questions? Please let me know.

Thanks,
Toby Abraham
United Nations

Reply

Shib

June 23, 2012 at 2:37 pm

Hi Shiva,

I have a requirement of merging two graphs into one in OBIEE 11g

G-1: Year Vs Sales Revenue
G-2: Year Vs Sales Qty

Can you let me know any clues about this…

Thanks in advance for your help..!

-Shib

Reply

bhavya

June 29, 2012 at 10:08 am

hi Siva i have a doubt hope u can help me in this.
Can we create a report with some dashboard background? like water mark or any thing else

Reply

padma

July 9, 2012 at 1:16 am

Navigation to another report is working for Chart,Butnot working for PIVOT Table

Reply

padma

July 9, 2012 at 1:51 am

Navigation to another report is working for Chart,Butnot working for PIVOT Table.

I have summary report which is navigating to Detail report . I have case statement formula in Summary report and gave the same formula in the detail report and is prompted .

But when I click on the Chart it is navigating to Detail report and displaying the records based on the filter condition.But when i click on the pivot table , the detail report is displaying all the records. The fliter condition is not passing to the details report for Pivot table.But working for chart type.

Please help me with this issue.I have beenstrugling to resolve the issue.
The formula which i am using is :
case WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” BETWEEN 1 AND 15 then ‘1 – 15′ WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” BETWEEN 16 AND 30 then ’16 – 30′ WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” BETWEEN 31 AND 45 then ’31 – 45′ WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” BETWEEN 45 AND 90 then ’45 – 90’ WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” > 90 then ‘> 90’ else ‘<= 0' end

If I have to Cast the above formula, How should I do it.

Appreciate for your help.
Thanks.

Reply

Arun

July 9, 2012 at 11:36 am

Hi Siva,

i need ur help..i want to make different sechama in physical layer..from same database.
but now i m trying this i m getting error..in view data.e.eg….sechma name….Auto..and personal loan…and my sechma name in database is RCAPP when i change the name auto to RCAPP..i can show data other wise in auto i m not able to view data.

Please help me in on this issue.
Thanks in Advance.
Arun

Reply

Janardhan Reddy

July 24, 2012 at 9:31 pm

Hi Shiva, I have a quick question on Oracle BI mobile App from my iphone and trying to login to the BI presentation server but getting below error:
Authentication Error: Server Authentication Failed: Could not connect to the server. [-1004]

could you please send me the steps for the configuration as I did something wrong while configuring.

Thanks in advance Shiva,

Janardhan

Reply

Mihir Sharma

July 30, 2012 at 9:54 am

Hello Mr. Shiva. I’m kinda fresher to the obiee11g. and i keep reading your blogs as and when required. recently i’ve been stuck up to the ‘Bins’ in BI Answers. the bin is working fine if i add it to normal dimensions such as company name, employee, department, even with year, quarter and months.
but……….when i add a bin to classify(or to group) the result for the date, lets take my e.g. i’m trying to classify ‘AP Invoice Amount’ facts depending on ‘Payment Due Fiscal Day Date’ dimension column. and as a ‘bin’, i add the filter ‘Payment Due Fiscal Day Date’ is between. and give the dates as ’01/01/2008 12:00:00 AM’ and ’12/31/2012 12:00:00 AM’ wiz a standard format in OBIEE,its giving me the error like (Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near : Syntax error [nQSError: 26012] . (HY000)
SQL Issued: SELECT CASE WHEN “Payment Due Date”.”Payment Due Fiscal Day Date” BETWEEN timestamp ‘2008-01-01 00:00:00’ AND timestamp ‘2012-12-31 00:00:00’ THEN Year between ELSE “Payment Due Date”.”Payment Due Fiscal Day Date” END FROM “Financials – AP Invoice Aging”).
Plz help me to get out f ds..!!
Waiting for your earliest and positive response.

Reply

Gaurav

August 8, 2012 at 10:07 am

Hi Siva,
We are authenticating against Microsoft AD and authorizing against the Oracle database table.The authentication and authorization works fine but under My Account–> Roles and Catalog ,I am not able to see the correct application roles and webgroups.This is what we did:-
1. We upgraded the OBIEE 10g rpd and catalog in the OBIEE 11g Windows environment .Everything works fine.We are able to see the correct application roles and webgroups under the Roles and Catalog tab.
2. We imported the 11g rpd and catalog into Linux OBIEE 11g environment and created the application roles and groups manually in EM.Also created the catalog groups using Administration link in front end.When a user logs in ,the users sees the correct application role but not the webgroups.
3. We imported the same 11g rpd and catalog into another Linux environment (which is clustered) and did the same steps as Step 2,now the user neither sees the application roles nor the web groups.
In all the three environments ,if we do Manage Sessions ,we see that the variables are populated correctly for the user.

Could you let us know why Roles and Catlog tab is behaving differently?

Reply

sandeep

August 15, 2012 at 10:46 am

i want to purge all the current date query from cache

Reply

Barkha Atwal

August 18, 2012 at 11:19 am

I’m not sure why but this site is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I’ll
check back later on and see if the problem still exists.

Reply

Kiran

August 19, 2012 at 2:19 pm

Hi shiva,
I have a requirement in obiee 11g…
How to change the background color of a graph to change dynamically based on the column value(for eg:revenue,if revenu > X or revenue <x).

thanks in advance…

Thanx&regards
kumar

Reply

Emeka

September 25, 2012 at 3:26 pm

hello can someone please email me

Oracle BI 11g R1 Create Analyses and Dashboards Volume 2 Student Guide with the labs???

emekachu@googlemail.com

Reply

Abdul Jabbar

October 7, 2012 at 1:28 pm

Hi Siva,
It is nice to see you blog,
i have installed OBIEE11g 11.1.1.6.0 on Win32 bit server and i want update/apply the patches 11.1.1.6.2 BP1 on that. Can u please explain me the steps how to do.

Thanks in advance

Reply

RSD

October 15, 2012 at 1:51 pm

Hello Shiva,

I am working on OBIEE 11.1.1.5. I have to include report header to display page number, date and title in the analysis and the analysis has to be exported to pdf. I am able to see the header on pdf format of the report(analysis) but the header is not showing up when this analysis is added to a dashboard and also when exported to pdf(the dashboard has a prompt and the report should run for the dates entered). The report header is not showing up in dashboard.

Is there any workaround for this or I am missing any OBIEE settings?

please help.

Thanks

Reply

trevor kelly

November 9, 2012 at 1:57 pm

Hi

I am building a report in obiee 10g and am calling another report using the project id for the sub report I only wish to pass in the first 4 characters. For example on the main report the project is 70001 which is the parent project id I only want to pass in the first four characters 7000 ie in sql you would use a substring 1, 4. In obiee can I only pass in the first four characters of the database field Is this possible

Many Thanks
Trevor

Reply

sravan madddineni

November 10, 2012 at 11:15 am

hai shiva
got a problem

iam unable to startup presentation services and scheduler in 11g

Reply

Bantu

November 25, 2012 at 3:45 pm

HI shiva, Its nice to see your blog,
I have installed OBIEE11g and have integrated with ebs r12 but when i try to aceess OBIEE from ebs it says User prohiited and also iam unable to open rpd in online mode thru weblogic as user/password and even i can’t access answers page directly says login paswd failure.Could you pls help me to sort out this issue.

Reply

Jaswanth

December 14, 2012 at 8:01 am

Hi Bantu,

You are not able to login because your Weblogic user is not an EBS User and you integrated both EBS and OBIEE. You need to create an Administrator user in EBS and pass the application roles to OBIEE11g and provide Administrator access to the newly created user.

Reply

Bantu

November 25, 2012 at 3:47 pm

HI shiva, Its nice to see your blog,
I have installed OBIEE11g and have integrated with ebs r12 but when i try to aceess OBIEE from ebs it says User prohiited and also iam unable to open rpd in online mode thru weblogic as user/password and even i can’t access answers page directly says login paswd failure.Could you pls help me to sort out this issue.

Thanks in advance

Reply

Kiran

December 11, 2012 at 1:40 pm

Hi Shiva,

I have arequirement like this…
I have two timeperiod prompts.
One contain prompt values as YTD,LM,LQ,L6M and second prompt contains month name values(month name is prompted).
If I select YTD value from 1st prompt the report showing data for year to date.This is expected behavior but My requirement is if user select value from first prompt then click on apply and again if he selects values from second prompt(i.e month name) the report should display data according to second prompt.

Thanks in advance.

Reply

Amol

December 27, 2012 at 7:05 am

Hi Shiva,

Is there a way to add scroll bar on a chart using OBIEE publisher?
I want to have a chart with all categories shown as bars but only 5 to be visible by default. But if user wants to see more he should be able to scroll to right say and can see remaining bars.

Thanks in advance.

Reply

Hemanth

January 5, 2015 at 9:29 am

Hi Amol,

I was also searching for the same requirement had you got rectified this problem.if you got the solution for this will you please suggest me how to overcome this.

Thanks in advance.

Reply

PK

January 15, 2013 at 11:47 am

Hi Sihva, Need your help, Is it possible to have google like search in OBIEE Prompt OR anywhere in OBIEE. User want to search on many attributes (Supplier Name, Supplier Leader Name, Supplier CODE, etc.. ) in one box…

Thanks
PK

Reply

Usha

January 28, 2013 at 4:53 pm

Shiva,

I have one question on OBAW data model, What could be the size to install OBAW on existing OBIEE 11g.

Thanks in advance,
Usha.

Reply

Aneesh

February 11, 2013 at 8:08 am

Hi Siva,

How r u ? This is aneesh from DC. I am facing one issue in Mapviewer OBIEE11g. When i open the mapviewer report , zoom level shows as 0..when double click it will it will set to level 1.How to set default zoom level as 1 in Mapviewer report?
Regards
Aneesh

Reply

Asif Iqbal

February 25, 2013 at 9:46 am

I am using OBI 10g R2. I am facing problem with its browsing in Internet explorer 8 and 9 on Windows and unable to drilldown reports in Safari on imac. I can see reports and graphs on imac in safari browser nut unable to drilldown. Whereas on ipad/ipad2 i am even anable to see any graph. Please help in this regard how this problem can be resolved???

Thanks & Regards,

Reply

Arun

March 5, 2013 at 12:26 pm

I have an issue with the AGO function.
I have used a formulae some thing like below.

Ago(“CCLRDC”.”Fact – Balances Measures”.”YTD Balance” , “CCLRDC”.”Period”.”Month” , 3)

Similarly like for month 2 and month 1.Well the point is I need a ytd bal for the prev 3 months and current month too.
When I pass the filter as APR-2012 im getting data for APR-12,MAR-12,FEB-12,JAN-12 But
When I pass the filter as MAR-2012 im only getting data for MAR-12,FEB-12,JAN-12 but could not get data for DEC-11

Reply

Rajeev

March 8, 2013 at 3:39 pm

Hi Shiva,

I have a requirement to calculate average(of a column) for a selected date range(from prompt) for a particular day.
E.g If user select the date range and then select Sunday from Dashboard prompt then it will count the no. of Sunday’s from the date range and calcuate the avg.

Please help me to get this done.

Thanks…

Reply

Mary

March 9, 2013 at 3:24 am

Hello Shiva,
I hope all is going well for you! We miss talking to you.
I’m wondering if you can help us figure out why we keep having problems with security and the catalog. Today I opened a ticket with Oracle because I can’t access the permissions on some folders. When I highlight the folder and click Permissions, nothing happens. I then went into Catalog manager to try and assign access and I got the error “Error retrieving user/group data from Oracle BI Server’s User Population API”. In the OBIPS log I see errors related to the GUID. We haven’t replaced the catalog or repository so I don’t understand how they’d get out of sync. We had and issue previously due to a group name having ( ). Anyway, it seems the GUID continue to cause us problems and users can’t access. I don’t want to refresh the GUID until I figure out what caused the problem. Any ideas? You’re help is appreciated!!! Mary

Reply

srinivas

March 17, 2013 at 5:51 am

Hi Siva,
I have created a report in area view of graph. But i was unable to give the different colors for each area of the view. I am obiee 11g client tool. So please suggest me.

Thanks & Regards
Srinivas B

Reply

Mahesh

March 19, 2013 at 5:45 am

Hi Shiva,

Original URLs:

http://localhost:9704/analytics
http://localhost:7001/em
http://localhost:7001/console

But as per the requirement we want to change the URLs as below.

http://localhost:9704/appname/analytics
http://localhost:7001/appname/em
http://localhost:7001/appname/console

Please Help us.

Thanks,
C Mahesh

Reply

Shiva Molabanti

April 17, 2013 at 10:14 pm

Mahesh,

You can do this in following ways:

1. You can integrate with any webserver and configure a virtual directory to proxy the requests with a named location module definition.

2. look at the Configuring Resource Availability and URL Generation: http://docs.oracle.com/cd/E21764_01/bi.1111/e10541/configloadproxy.htm#BABJBIIE

3. deploying the analytics.ear file with a new deployment descripter.

Thanks,
Shiva

Reply

NT

March 27, 2013 at 7:51 pm

Hi Shiva,

Can you please update this blog? What is the OBI Version that this is officially supported in?

Thanks

Reply

Shiva Molabanti

April 17, 2013 at 10:07 pm

Thank you NT. Been busy with the other innovations. The officially supported version as of today is till OBIEE 11.1.1.7.0

Thanks,
Shiva

Reply

phen375 uk

March 29, 2013 at 2:48 pm

I’ve been browsing online greater than 3 hours lately, but I never found any interesting article like yours. It’s lovely value enough for me.
In my view, if all site owners and bloggers made excellent content as you probably did, the net will probably
be much more useful than ever before.

Reply

Pavan

April 11, 2013 at 7:19 pm

Hi Shiva,

I have been following your Blog from longtime, But this is my first question to you…
I have a requirement which is like this i need to put a scrolling text(DAC Load is till in Progress)
in answers landing page next to
(Alerts!- Dashboards- Answers- More Products – Settings – Log Out Search).
I was thinking if we can locate the Answers Page code(Java/Html) should help us, Just a thought.
Could you pleas help me out in solving this issue.

Thanks in Advance

Reply

Shiva Molabanti

April 17, 2013 at 10:05 pm

Pavan,
I dont think so you would add a marquee/sliding text in the links. but you can add a link next to the Menu links as explained in http://docs.oracle.com/cd/E28280_01/bi.1111/e10541/answersconfigset.htm#BABHAEIF

Thanks,
Shiva

Reply

Vikas

April 12, 2013 at 6:26 pm

Hi Shiva,

We are using OBIEE 11.1.1.6.4, we want to create a Virtual directory mapping in weblogic server so that we can place our static image files to access from the application URL.

To do this activity, we have performed following steps –

1) Navigated to C:\OBIEE11G\Oracle_BI1\bifoundation\jee

2) Open analytics.ear file

3) Existing code in weblogic.xml is: (if weblogic.xml is not present we need to create the file with below code)

/analytics

4) We have added virtual-directory-mapping tag; After adding virtual directory mapping tag, the code in weblogic.xml is

/analytics

D:/virtualdirectory
/images/*
*.jpeg

5) We have created a folder virtualdirectory under D: drive. And then created a folder images within folder virtualdirectory.

6) Then we have placed an image (lets say) test.jpeg within image folder.

7) Restarted all BI services,

8) Now when have created a report where we have placed the URL (in the formula, someting like this – > http://localhost:9704/analytics/images/test.gif).

On running the report and clinking on the URL (which we have made appear as link), a seperate browser window opens up and displayes the image

Now we are able to see the image, it’s working perfectly fine.

However If we paste the above URL in a seperate browser then also it will displays the image without any authentication. Means anybody can copy the URL in the browser and see the image without login to OBIEE. This is causing security issue.

So our requirement is, on pasting the URL in browser, the images should not be shown (or there should be 404- error). first it should redirect to OBIEE homepage and when authentication is done then it should display the image. Or the image should be displayed only when user has already logged into OBIEE and clinking on the link to open the image from the dashboard page.

Request you to please advise if any inputs to acheive this.

Thanks!
-Vikas

Reply

Vikas

April 12, 2013 at 6:30 pm

Seems the my previous questio didn’t post completely, so posting it again here–

Hi Shiva,

We are using OBIEE 11.1.1.6.4, we want to create a Virtual directory mapping in weblogic server so that we can place our static image files to access from the application URL.

To do this activity, we have performed following steps –

1) Navigated to C:\OBIEE11G\Oracle_BI1\bifoundation\jee

2) Open analytics.ear file

3) Existing code in weblogic.xml is: (if weblogic.xml is not present we need to create the file with below code)

/analytics

4) We have added virtual-directory-mapping tag; After adding virtual directory mapping tag, the code in weblogic.xml is

/analytics

D:/virtualdirectory
/images/*
*.jpeg

5) We have created a folder virtualdirectory under D: drive. And then created a folder images within folder virtualdirectory.

6) Then we have placed an image (lets say) test.jpeg within image folder.

7) Restarted all BI services,

8) Now when have created a report where we have placed the URL (in the formula, someting like this – > http://localhost:9704/analytics/images/test.gif).

On running the report and clinking on the URL (which we have made appear as link), a seperate browser window opens up and displayes the image

Now we are able to see the image, it’s working perfectly fine.

However If we paste the above URL in a seperate browser then also it will displays the image without any authentication. Means anybody can copy the URL in the browser and see the image without login to OBIEE. This is causing security issue.

So our requirement is, on pasting the URL in browser, the images should not be shown (or there should be 404- error). first it should redirect to OBIEE homepage and when authentication is done then it should display the image. Or the image should be displayed only when user has already logged into OBIEE and clinking on the link to open the image from the dashboard page.

Request you to please advise if any inputs to acheive this.

Thanks!
-Vikas

Reply

Vikas

April 12, 2013 at 6:40 pm

I copied the weblogic.xml before and aftet making the changes, but not sure why the that code is not getting copied in the post.

Reply
Shiva Molabanti

April 17, 2013 at 10:02 pm

Hi Vikas,
This is expected behaviour. Since your deployment is not undelined with any of the security model, that will not expose to any authentication schema. SO I would recommend to create the images directory within analytics application, so that the the images also will be guard by OBI Security.
do similar to http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1113/customizing_obiee11g/customizing_obiee11g.htm

Thanks,
Shiva

Reply

Venkat

April 15, 2013 at 9:31 am

Hi Shiva,

My Name is Venkat. I am trying to install BI APPS 7.9.6.4 on 11.1.1.6.9, but not able to install, its saying that Make sue Admin server is up and running. But when i see from console and EM all are up and running. can you please let me know the issue…its more helpful am struck up this place since more than 2 weeks.

and also i need to check you few question 11G:

1. Loop back adaptor: am still getting confused on how it works. if it DHCP system we need to have loop back and static IP. when am installing in Virtual machine which has static IP do we need loop back and make the changes in host file…can you please explain on this..

2. JDK : do we need external JDK installation before OBIEE…i have read that by default we have built jdk available in obiee. can you please explain….

Many thanks,
Venkat

Reply

Shiva Molabanti

April 17, 2013 at 9:54 pm

Venkat,
Even Admin server up and running, The BI Apps installer will contact teh nodemanager to know their status. looks like the nodemanager is not being pinged properly. Just change the script used by installer to connect to NM.

1. Make a backup copy of \Installers\Oracle_BI_Applications\script\wlst_nodemanager_connect.py
2. Modify \Installers\Oracle_BI_Applications\script\wlst_nodemanager_connect.py
The content should look as follows:
##
WLST script to test connection to NodeManaer to check if it is running
##
This script expects the following arguments:
##
1. wls.host (localhost)
# 2. wls.port (7001)
# 3. wls.user (weblogic)
# 4. wls.password (weblogic)
# 5. middleware.home (C:\oraclebi)
# 6. domain.home (C:\oraclebi\user_projects\domains\bifoundation_domain)
# ===================================================================
import sys
import os
import xml.dom.minidom
# Check the arguments to this script are as expected.
# argv[0] is script name.
argLen = len(sys.argv)
if argLen -1 != 6:
print “ERROR: got “, argLen -1, ” args.”
print “USAGE: wlst.cmd wls_connect.py WLS_HOST WLS_PORT WLS_USER WLS_PASSWORD
MIDDLEWARE_HOME DOMAIN_HOME”
print ” eg: wlst.cmd wls_connect.py localhost 7001 weblogic welcome1 C:\oraclebi
C:\oraclebi\user_projects\domains\bifoundation_domain”
exit()
WLS_HOST = sys.argv[1]
WLS_PORT = sys.argv[2]
WLS_USER = sys.argv[3]
WLS_PW = sys.argv[4]
MIDDLEWARE_HOME = os.path.normpath(sys.argv[5])
DOMAIN_HOME = os.path.normpath(sys.argv[6])

3. Run the OBIA 7.9.6.3 installer. You should now be able to proceed past the screen and continue as normal. Check box the BI Applications you want to install.

Coming to other questions, You dont need a loopback adapter if your machine is not listening on multiple IPaddresses. And you dont need to install the JDK. that will come with OBI software.

There are some scenarious where you need to install JDK first to run your OBIEE on the specif flavour of Java…

Thanks,
Shiva

Reply
- Venkat
  
  April 24, 2013 at 11:18 am
  
  Thanks Shiva for your replay. now able to install bi apps. After BI apps installation, when am trying to login to analytic url, it saying username and password is incorrect. it happens twice. I tried like taking a back up of apps install folder and i add that folder to bi home folder(new installation) without apps installation its working. can you please let me know ….
  
  my versions: 11.1.1.7 and BI APPS 7.9.6.4
  
  Thanks,
  Krishna

Pavan

April 19, 2013 at 4:56 pm

Hi Shiva,

Please find below scenario

I need your help/ suggestion on setting a presentation variable through java script/Jquery. I am working on a task to set the presenation variable to a predefined value on click of a hyperlink to capture the user action and planning to use the presentation variable value to set the conditions for the analysys. I have 4 hyperlinks and and the analysis where condition will vary depeneding on the hyperlink clicked.

Let’s say i have

Hyperlink1>>Hyperlink2>>Hyperlink3>>Hyperlink4

I will define a prompt/session variable Where1 and set its value to 1,2,3 or 4 depending which heperlink user has clicked and i will use presenation variable Value to decide the where condition in the analysis avialbe on different dashboard page.

My ultimate goal is to update session/presentation variable on user click so that i refer this value to decide which column to be filtered. I know if i use propmts it will be simple but user wants UI as hyperlinks.

Reply

Don

April 23, 2013 at 6:07 pm

Hi Shiva,

I’m trying to build a report to do a change in working capital analysis and can’t figure out how to build the report (in Answers) where the first column will be current month Actuals, the second column is the prior month Actuals.

I would think this is a fairly common request for an accountant but cant find anything referencing this request.

Reply

Suman

May 14, 2013 at 5:33 pm

Hi Shiva,

I have an issue in my report where YTD values show full year values. I am using OBIEE 10g

Ex:

If I give filter as 2013 to the YTD column its gives correct data i.e from jan 2013 to may 2013
If I give filter as 2012 to the YTD column it gives whole data for the given year 2012 i.e from jan 2012 to dec 2012

My YTD code is

TODATE(Core.”Fact – Spend and AP Invoice Distribution”.Spend, Core.”Date”.”Year”)

It would be great help if some one could suggest on this behavior.

Thanks

Reply

Roderick

May 15, 2013 at 10:16 pm

Whilst opting surgical procedures, one can opt
for both of the two approaches, viz. At the time you have applied the cream, the moles get infected.

Reply

Chandra

May 24, 2013 at 10:59 pm

Hello Shiva,

I am sure you would have come across this scenario in your different project.

Need to know how to clear the cache (Presentation and BI server cache Automatically) After the ETL Loads in OBIEE 11g.

Was able to clear the cache automatically after each ETL Load through a Control M Job, But how can we clear the Presentation Cache and also if we can seed( not through Agents) the whole dashboard.

With Regards!
Chandra

Reply

Shiva Molabanti

May 27, 2013 at 10:42 pm

Chandra,
You can create a Control M task with OS command that i have listed in my blog to clear the presentation cache @ https://shivabizint.wordpress.com/2013/05/03/how-to-clear-the-query-cache-in-obiee11g-presentation-server/ and then schedule as like a task.

Thanks,
Shiva.

Reply

Pavan

June 4, 2013 at 5:55 pm

Hi Shiva,

Is there any document or video present for installing and checking new features of Mobile OBIEE 11.1.1.7.1. I mean OBIEE 11.1.1.7.1 installation on Mobile/ipad.

Thanks,
Pavan

Reply

PaulShumbayaondaPaul

June 6, 2013 at 1:59 am

Hi Shiva,
I want to learn the BI Apps 11.1.1.7.1, can you direct me to some resources who teach it online starting from installations. Thanks

Reply

madan

June 6, 2013 at 3:04 pm

Hi All ,

My clinet calculates week from sunday to saturday ,Now last week of 2012 are 30 and 31,When we look in W_day_d 30 and 31 are showing as week 53 but as per clinet’s calendar these should be under week 1 of 2013.Can any one please help me out with the logic

Thanks in Advance

Reply

Shaid Greeff

June 13, 2013 at 9:21 am

Hi Shiva, I am looking for a Technical Reference Architecture and Sizing guide for BI Apps 11.1.1.7.1.

Also the documentation is not specific about loading certaing modules of the EBS, e.g. Financials, Procurement or HR.

Reply

abdul tawab

June 27, 2013 at 1:27 pm

Hi Mr Shiva,
i am new in this area and , i am looking for a install OBIEE and OBIA and link ERP oracle R12 .
1- what is map Road to install OBIEE and OBIA with used Oracle Data integration
or
2- used informatica 9.1 + oracle DAC

explain me
abdul tawab

Reply

Shilpa Jain

July 1, 2013 at 1:21 pm

Hi Shiva,

We have only the the V305 virtual image available for download and not the standalone. The VI is huge in size . Can you provide me with the obiee RPD and webcat if you have already downloaded the image.

Thanks in Advance

Shilpa

Reply

seetha

July 7, 2013 at 4:49 am

hi….
i have a small doubt… what kind of problems mostly we are facing in obiee when once enter into the real time work ….

Reply

balaji

July 9, 2013 at 9:34 am

Hi Shiva,

I am planning to take BI Apps certification , can u help me on th
is plz.

Reply

S

July 11, 2013 at 4:27 pm

I have a following simple report :

Fiscal Qtr Product Numbers Heads
2012Q4 1100 220
2012Q3 1000 230
2012Q2 1200 200
2013Q1 700 190

What i need to show is a arrow up or down depending current qtr verus previous qtr. for example : for Product numbers it was gone up from Q3 to Q4 from 1000 to 1100 so i would like to show a green arrow indicating positive trend . similarly between Q3 and Q2 number when down, so a downwards red arrow indicating negative trend.
i need to show this for both columns Product Numbers and Heads

I know we can get the images through conditional formatting but i am unable to do so for a difference between qtrs. Any suggestions on this would be appreciated. I am open to changing report design also to suit this.

Reply

uma maheswararao

July 15, 2013 at 6:30 am

Hello Shiva,

this is uma, i have created one dashboard prompt and analysis report ,
now i need to add that presentation variable to analysis report its giving below error
can u pleaze respond quickly

Reply

Ravikiran

July 22, 2013 at 10:10 am

Hi All,

I need hide the “View Display Error”, which comes when you configure the limiting number of records for a user or Group.
Can anyone please help me, how to hide the view display error and to display our own message, as OBIEE View Display error is very long.

Thanks in advance,
Ravikiran

Reply

Prashanth

July 30, 2013 at 3:06 pm

Hi Shiva,

Can we create an Action link based on an Application Role?
If not can we can customize the message that appears to user instead of access denied for user to path (only for this report)

We are using 11.1.1.7

Thanks,
Prashanth

Reply

Prashanth

July 31, 2013 at 3:47 am

Hi Shiva,

Can we display an Action link based on User role?
If not can we customize the message for unauthorized users (instead of access denied for user path /…/ ). only for this report

Thanks,
Prashanth

Reply

Kavi

August 6, 2013 at 1:05 pm

Hi Shiva,

I have implemented the OBIEE 10g using prompt as report selector. for example, I have used 3 reports in dashboard with prompt as selector and used GN for each report. if i didn’t select anything from prompt also in dashboard page, running the SQL query for all the reports on the backend. Even when I select one of the reports from the drop down list, I see many other SQL still running on the backend. Since our report is taking long time to run, this puts a lot of load on the database. Is there a way to stop the queries from being generated and wait for the user’s response?

Reply

ajay

August 6, 2013 at 5:07 pm

Hi Shiva,
I am having an issue with dashboard prompt, following is my requirement
i am using two columns Account Number and Account name in a dashboard prompt. User will select Account number and related account name should be displayed .
Example : account number account name
Ar1456 Automative group
FL376 Filtration group

when user chose Ar1456 in account number, Automative group should be displayed in account name.
I am able to see the account name in drop down ,but user not interested in choosing from drop down, User want it to be displayed automatically.

Thanks in advance.
kumar

Reply

Anti Aging

August 7, 2013 at 10:41 am

Greetings! Very useful advice in this particular
post! It’s the little changes that make the most important changes. Many thanks for sharing!

Reply

kalyana

August 30, 2013 at 9:20 am

Hello All,

I was trying to write back to an Hyperion Essabse Cube With the Below Procedure..

1.The version of OBIEE which I was using is OBIEE 11.1.1.7 (on Windows 64bit) and Essbase also on 11 Version (On Windows Server).

2.At First I had made used of the Custom Java script which I placed in the location of OBIEE
i.e(D:\MiddleWare\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\b_mozilla\actions) (Script attached).

3.The Custom Script consists of Execute_lsql function which is used to execute the logical sql commands sending it to the biserver and then send update to essabse cube with the help of connection pool.

4.The Summary Statistics logging has been disabled in the NQSConfig.ini File.

5.The column which I wish to write back has been set Writable in BMM layer and the read write permissions has been given for that column in the presentation layer.

6.The Data base object and the connection pool object are also given allow Execute Sql Requests privilege in the physical layer.

7.The Write back privilege has been given to the user from the analysis administration .

8.A report has been created with four columns and for the measure I have applied the write back with simple update statement as follows by selecting invoke browser script option from the action links in the column properties .
update “Sample”.”Basic” set “Total Expenses” = @{p1} where
“Sample”.”Product”.”Product – Default” = ‘@{p2}’ and
“Sample”.”Scenario”.”Scenario – Long Names” =’@{p3}’ and
“Sample”.”Year”.”Quarter” = ‘@{p4}’

9.The Following Policies were given to the user who is logging in to the system ,Screen Shot Below..

10.The problem is when I am clicking on the measure in the report and trying to update the value the values doest not get updated in the cube nor its not throwing any error to ,but when I check the query being generated its hitting the right connection pool and I have given the right permissions.

Did any one come across this problem or any more steps need to be added,Any Suggestions Aprreciated.

Thanks
Kalyana

Reply

Jesus

September 3, 2013 at 10:14 pm

Hi Shiva:

I have two prompts ( based in column value)

The firts prompt take the values of this column “Reporte de Release”.”Id Release” , when i select one value in combo prompt that will be saved on Presentation variable ID_Release.

The second prompt using the next expresion to filter values.
SELECT MAX(“Reporte de Release”.”Sesion”) FROM “ASCP/MRP” WHERE “Reporte de Release”.”Id Release” = @{Id_Release}

When i run the first prompt and select one value, the value results of second prompt is filter OK but i need to select the value in the combo prompt to assig a second Presentation variable (ID_Session).

Let me put and example

Values of first prompt
Id Release
81
82
83

Values of Second promt
Id Release Sesion
81 2013-01-01
82 2013-02-01
83 2013-03-01

If I select 81 in the first prompt , the second prompt only show the value of 2013-01-01 but i need to select them to be reflected in a presentation variable ID_Session)

You know any opcion to auto commit or auto select automatically the value of the second prompt.

Best Regards!!

Reply

obieenj

September 5, 2013 at 4:03 pm

How do I get the data for the last day of the selected date range thru RPD?

The prompt from the front end is picking up a date range ( example june 2013).

I need to pick the last day of the selected period and then pull the fact data for that day.

so, the logic would be something like this:

case

when

fact.date=last day of the selected period( I tried different ways to try this. nothing working)

then

fact.amt

else

0

end

Reply

neehareddy

September 12, 2013 at 4:23 pm

please give me ur email id shiva

Reply
- Annu
  
  September 19, 2013 at 4:16 pm
  
  Thanks for responding. My email id is karr_annu@yahoo.com
  
  I would appreciate if you can follow up with my question. Regards, Annu Aggarwal

Rejo

September 20, 2013 at 1:32 pm

Hi Shiva,

I have a scenario.
I am using a column in analysis is ‘age’ and it is throwing error in criteria is below
“View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 46033] Datatype: 25 is not supported. (HY000) ”

I have analyzed and my observations are below:
1) the “age” is derived column (current_date – birth_date) coming from one db view.
2) the query being generated by obiee is fetching data in database(teradata).
3) the “view data” of source table in rpd is also throwing same error mentioned above.
4) the datatype of column “age” is showing in rpd is varchar.

Request you to suggest a solution.
Looking forward your help.

Thanks,
Rejo

Reply

evren

September 24, 2013 at 4:04 pm

Hi,

when i was sarching internet i found your web site. I upgraded my system to Oracle BI 11.1.1.7 after that my layout measures disappered.

http://prntscr.com/1t7fay

when i connect from ip 10.1.1.0/analytics it is fine, but when i connect as http://www.firm.com/analytics layout measures not seen.

do you know what is the problem?

Thanks a lot,

Reply

mohan

October 6, 2013 at 5:23 pm

I have requirement to filter single report depending on user selection. he can select Calendar Quarter or Fiscal Quarter, depending on his selection we have to display data. I have implemented this logic with presentation variables & it is working fine. Here the catch is DRILL is not working properly..it is drilling from Quarter to Day level directly and skipping MONTH and WEEK level. I am using 11.1.6.2 version.
Note :1) Hierarchy is perfect..Year–Quarter-Month-Week-Day..
2)I have used case statement to implement this logic..this logic is creating problem for DRILL DOWN.

As alternative I have created 2 reports..one is for calendar and second id fiscal & kept them on the page. BY using condition I want to display only single report depending on user value..In Condition other than rowcount I am not able to check any condition. Please suggest ASAP. Thanks

Reply

Chad

October 20, 2013 at 1:51 pm

We currently have Siebel CRM, Informatica/DAC for ETL and OBAW on Oracle and OBIEE for reporting. We are having discussions to move to Hadoop.

– What are some key considerations to do this transition?
– How would our current architecture change?
– How would the OBAW data model have to be transitioned onto Hadoop hdfs?

Just early stage discussion so not sure if my questions make very much sense at this point. Looking for some direction or a discussion…

Thanks in advance,

Reply

Santosh

October 24, 2013 at 1:53 pm

Hi Shiva..
can you please explain how to create MTD and Prior MTD in rpd Level..i have been struggling with this problem for couple of days..first time i created MTD with TODATE(measure,Month) and For Prior Year MTD I took AGO(MTD Measure,year,1) but getting error when i add these columns in criteria. Iam waiting for your replay..

Thanks

Reply

Santosh

October 28, 2013 at 11:57 am

Hi Shiva,

I am not able to create a Prior Year(Previous Year) MTD in RPD in OBIEE 11g..

First i created MTD using TO DATE(Measure,Month) then after that for Prior Year MTD taken AGO((MTD Measure),year,1).

Getting error When i see the results in answers …can you please give any suggestion

Thanks

Reply

Troy Geri

November 6, 2013 at 6:14 am

Hi
One of our report developers came back with this comment regarding BI Publisher

OBIEE has 2 different reporting tools (BI Publisher and BI Answers), BI Answers allows report end users to sort the data (by column) but BI Publisher reports don’t. Unfortunately, some report layout/formatting require the use of BI Publisher over BI Answers, hence in some reports sort functionality is not available to the end report user

Is this correct?

Reply

Gowtham

November 18, 2013 at 6:05 am

Hi Shiva,
here i am having a rounding issue with aggregation (sum) of column having revenue . I am working Postgresql as datasource and i am getting only the floor values instead of rounding values pls sugges asap

Reply

lea

November 26, 2013 at 4:53 am

How do I freeze the first column in a table, where the header is already frozen?

Reply

Obiee Wan KenObiee

December 8, 2013 at 11:55 pm

Can someone help me, I need to know if you can link two pivot tables to one column selector in OBIEE 11g, Please could you respond explaining how… Thanks 🙂

Reply

kishore

December 9, 2013 at 10:10 am

how to get revenue up to 3 deciaml values, without using dataformate option.
i tried truncate. but its not shoeing the decial values,
can any one help?

Reply

Siva Budagam

December 11, 2013 at 12:39 pm

Hi Shiva,

Could you please provide solution for my query whihc i ahve posted in OTN…

here is the link

https://forums.oracle.com/thread/2611413

Many thanks..

Regards,
Siva Budagam.

Reply

Brayan

December 18, 2013 at 7:17 am

Hey whats does the following error mean , My query run successfully in oracle developer , but while generating the xml it gives the following error .
” error on line 2 at column 245: Opening and ending tag mismatch: img line 0 and span”

Reply

Lisa Huckins

December 24, 2013 at 3:48 pm

Hi Shiva
I am in OBIEE 10g of BI APPS Supply Chain and Order Management. In Order fulfillment, I have a sales order line fact table presentation that has multiple date fields. I have a Time dimenstion that is joined to the fact on ordered date so I can bring in the enterprise period for a report. I have 3 other date fields that I want to use in a report and show the related enterprise period for that date.

I understand that I can alias the W_DAY_D calendar table for each date, but I want to only present one Time dimension that works with any date. Is that possible?

Regards
Lisa

Reply

Chinnu

December 26, 2013 at 8:16 pm

Hi,

I have a requirement to display Previous week , QTD, YTD and QTD and YTD running Rate and Year over Year. In RPD I calculated all measures and when I create a report in obiee with all above measures I am not getting results in Year over year. I provided report filter with Week offset.

Year over Year is calculated using AGO function.

Please let me know solution.

Reply

obiquest

December 27, 2013 at 2:46 pm

Hi,Shiva Please provide me the solution

Hi,

I had a requirement that i want to show the top 5 revenue generated products for the year.

Dim col:-Product

FactCol:- revenue

Time Dim:-year

Description:- I had a prompt for year that it should show the default value as “current year”. when i select the year from prompt it should show the current year,current year -1,current year -2 data.

Example:- when i select ‘2013’ year in my prompt i should see the ‘2013’,’2012′,’2011′ data.

Report:- It has three col’s Year,Product,Revenue.

The report out put should be like this it should show the top 5 revenue products and remaining in ‘OTHERS’ by percentage wise.

Graph:- Based on the above result i should show the out put in Stack graph by current,current-1,current-2.

Please help me.

Thanks,

Obique007.

Reply

Muthukumar

December 29, 2013 at 6:34 am

Hi Shiva,

I have a requirement in obi 10g. Let me explain the scenario first.

In the dashboard page top we have dashboard links like MyDashboard,Home Page.

so my requirement is when i click on the home page link it has to show the list of dashboards containing under the home page and when i click on the some of the dashboard under that it has to show the dashbord under that without opening a new page.

It is like start>All Programs>Accessories> paint/calculator … so here everything will open as a popup instead of opening in a new window ..

My requirement is also like this .. when i click on the home page i need a pop up window which displays the list of folders under which inturn contains mulitple dashboards like menu and submenu

Reply

Saravanan Venugopal

January 29, 2014 at 6:49 am

Hi Shiva,

MY OBIEE 11.1.1.7.0 reports are disappear when we giving inputs to the dashboard. I am unable to see my dashboard.

Reply

MvD

January 29, 2014 at 9:21 am

Hi Shiva, can u please make an article about installing the new Oracle Mobile Security Suite (Bitzermobile). I think there will be a lot of questions for an article about this in the future, your Mobile app designer article was great too. It definately helped me out.

Thanks in advance
M.

Reply

Arjun

February 3, 2014 at 6:38 am

Hi All,

I have a dashboard in obiee10g, an image(company logo jpg file) is added to it using text or image section. I have configured an ibot to deliver the dashboard as a HTML to the email receipents ( as the end user wanted dashboard as the content of the email rather than an attachement). however when i deliver it as html, the image(company logo) is not displayed in the email instead of that an empty section is displayed. (image missing)

if i deliver it as any attachement other than html then the image is displayed in the attachment of the mail.

kindly post if any solution is available.

Thank you

Regards,

Arjun.

Reply

Venkat

February 4, 2014 at 4:06 am

Hi Shiva,
I like this blog, very informative and detailed and reliable. Thank you very much for your time and help.
I have a requirement where Report should be delivered via email on first day of each quarter containing previous quarter data. All Service Requests logged(Creation Date) in last quarter.
ExampleReport generated on first of April should contain all SRs created from Jan 1st to March 31 of that year,
As same, Report generate on 1st of Jan shouldcontain All SRS created of previous year last quarter.
Please give me detailed description on how to achieve this.

Reply

arjun

February 8, 2014 at 7:31 am

Hi Shiva,

I have a dashboard in obiee10g, an image(company logo jpg file) is added to it using text or image section. I have configured an ibot to deliver the dashboard as a HTML to the email receipents ( as the end user wanted dashboard as the content of the email rather than an attachement). however when i deliver it as html, the image(company logo) is not displayed in the email instead of that an empty section is displayed. (image missing)

if i deliver it as any attachement other than html then the image is displayed in the attachment of the mail.

kindly post if any solution is available.

Thank you

Regards,
Arjun.

Reply

Rituraj

February 13, 2014 at 12:30 pm

Hi,

Glad to see the blog

I want to know is there any way i can put a calender box beside a dashboard prompt so that end user can select date using that calender boxrather than entering it manually????

Thanks in advance

Reply

mheann asejo

February 20, 2014 at 2:06 am

Hi! Good morning!

How can I display a period of time in my report?
Sample, I want number of accounts from jan 1 ,2013 to jan 10,2013. Sat and sun not included

Output should be like this:
Accounts| 1st week | 2nd week
| Jan 1 to Jan 3 | jan 6 to jan 10
Land | 10 | 50
Air | 5 | 17

Reply

Mital

February 23, 2014 at 3:36 am

Can we have more detail on error report within OBIEE?

Reply

Thiru

February 23, 2014 at 12:07 pm

what happens when both logical keys are selected under logical level?

Reply

Aditya Sharma

February 26, 2014 at 7:38 am

Hi Shiva,

I’ve installed OBIEE 11.1.1.6. I’m having all the channels in DW_REPORT DB but in OBIEE dashboard, the dropdowns ‘Channels’ and ‘Locale’ are coming as empty. Any clue where I might be going wrong?

Reply

manoj

March 3, 2014 at 1:08 pm

Hi
Shiv

i was working with oracle apps table ,i was stuck on one table that has not primary key and FK
when i selected fnd lookup table column we got error, odbc error

I was got other tables query working fine

Reply

Nandini

March 3, 2014 at 10:14 pm

Hi,

We are trying to create reports using one table, we want to create time series drill down, drill down by year, month and week work fine, but when we drill down to the day level it gives wrong values.

All the values YTD, A year ago etc are wrong. Is there any particular reason for that.

Thanks

Reply

suresh

March 10, 2014 at 4:48 am

Hi,

when i create a report using two subject areas i will get an error like “no fact table exists at the requested level of detail” Can any one help me

Reply

Amarnath

March 12, 2014 at 12:30 pm

Hi Shiva,

To introduce my self this is Amarnath working in chain-sys on OBIA 11.1.1.7.1. when we are running the load on Financial Analytics in (AP). it is taking so many days, just i want to know how many days it takes to load.

Reply

Aman

March 16, 2014 at 2:21 pm

I have created an Agent in OBIEE 11g which kicks off at a specific time (8 am everyday). The problem is that sometimes by this time the underlying ETL process does not complete so the report kicked off by the agent shows inaccurate data. One way to rectify this is that I can reschedule the agent, i mean delay it by couple of hrs. But I am looking for event based triggering of agent. Like when my ETL complete then the agent should kick off. Is there a way to achieve this?

Reply

Sunny

February 4, 2020 at 5:11 pm

Did we get a response for this request ?

Reply
- Shiva Molabanti
  
  March 4, 2020 at 12:55 am
  
  What is the question?

anpur

March 17, 2014 at 9:04 pm

Hi,
I have just upgraded OBIEE from 11.1.1.6.6 to 11.1.1.7.1.
Report header and prompt background color is changed looks like it is shaded.
how do i remove shaded color?

Reply

Stan

March 26, 2014 at 10:05 pm

I’m new to OBIEE, but I was able to use VB Script that was invoke on the server by the running agent and get report as Excel spreadsheet ( I was using OBIEE v.11.1.1.6.0 on XP). In this version when I created a new action for Agent using ‘Invoke Server Script’, in “Define Parameters” column “Value” there was dropdown to select “Delivery Content” or “Condition Analysis” and types options to choose from PDF, Excel, etc.
Now I installed OBIEE v.11.1.1.7.0 on Windows 7 64-bit.
When creating a new action for Agent using ‘Invoke Server Script”, in “Define Parameters” column “Value” there is no dropdown with options “Delivery Content” or “Condition Analysis”– and types options like PDF, Excel, etc. How can I use VB script to create Excel file if I cannot see “Delivery Content” for ‘ Value’ column and options to select from (pdf, Excel, etc).
The only option available are “Session Variable”,” Repository Variable”, and “Request Column” . Is this a bug in OBIEE for this version?
Can you help?
Thanks,
Stan

Reply

lakshmi

March 29, 2014 at 12:02 pm

we are getting an issues with weblogic server getting stuck on which OBIEE is running.
whether it could be causing by reports or not ?

Reply

Mona

March 31, 2014 at 2:37 pm

Hello All,

Can some one let me know how to compare the current date value with previous date value in the same Column?

For Example:

protocol ID Date
1 07-July-2013
1 11-Aug-2013
2 24-July-2013
2 3-Sep-2013
3 21-July-2013
3 11-Nov-2013

Now in here , i have to find difference between the date and if date difference is greater that 15 days that count that protocol ID.

I ma having difficultied since i have find difference betwwen two values in the same column..

Any help is much appreciate.

Thanks in advance.

Reply

KNK

April 5, 2014 at 6:52 am

Hi Shiva,

I have requirement that whenever user export the dashboard page to PDF, the PDF footer should display a page number as(lets say we have 5 pages) 1 of 10, 2 of 10, 3 of 10…Do we have any configuration file to set this option.so that it can effect dynamically to all the dashboard pages…

Thanks in Advance..

Reply

Bruno

April 8, 2014 at 3:19 pm

Hi,
I’m trying to copy and paste a physical alias, but when i copy it i lose the joins related to the table in question. Do i need to replicate all the joins again or is there an easier way? I’m working with obiee 11g. Thanks in advance for your reply.

Reply

R

April 9, 2014 at 7:04 pm

Hi Shiva , I have a query in OBIEE-ESSBASE ,,,

It goes lyk this .. I have a parent child hierarchy … And i have to show the parent nodes till the ultimate parent in my report based on the node selected … And i have to build it in a way that the measure selected should be as per the node selected .

Reply

R

April 9, 2014 at 7:05 pm

Its bit urgent …..

Reply

Asfak

April 14, 2014 at 2:39 am

Hi, Getting eror iin agent triggered excel report, This report is displayed properly with data in OBIEE. When it comes into email inbox ,it is fileld with below error. Pleas help.
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 13017] User or application role has not been granted the Direct Database Access privilege to access the database ‘CGH-AEPSS’. Please verify the User/Group Permissions in the Oracle BI Administration Tool.Please have your System Administrator look at the log for more details on this error. (HY000)

SQL Issued: {call NQSGetQueryColumnInfo(‘EXECUTE PHYSICAL CONNECTION POOL “cp_sql_AEPSS” select CF.cas_dte_tme_reg …………etc..

Reply

Ayubjani Shaik

April 15, 2014 at 7:28 am

how we configure or Edit the grayed out Domain Member Mappings in Business Intelligence Applications Configuration Manager.

Reply

Parashiva C

April 15, 2014 at 10:26 am

Hi Shiva

we have a analysis in Development and QA( QA clustered Env) ,it has same logical query in DEV and QA
and no changes in RPD and pointing to different database.
In DEV -report generates 19MB tmp files and give result where as it generates more than 17GB tmp file and runs out of disk space …
when we compared the physical query from DEV & QA, found a difference in it even though report logic is same.

Any idea why it generates huge temp file and different physical queries.

DEV Physical Quey
SAWITH0 AS (select distinct T337993.CODE_VALUE_08 as c1,
T337993.PRIMARY_ROLE_NAME as c2,
concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME) as c3,
nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’) as c4,
nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’) as c5
from
W_RESOURCE_D T337993 /* Dim_Resource_RM */
where ( T337993.ACTIVE_FLAG = ‘Y’ ) ),
SAWITH1 AS (select count(distinct case when T337993.CODE_VALUE_10 in (‘GEH’, ‘GES’) then T337993.RESOURCE_OBJECT_ID end ) as c1,
count(distinct case when T337993.CODE_VALUE_10 in (‘CW’, ‘CW-ES’) then T337993.RESOURCE_OBJECT_ID end ) as c2,
count(distinct case when T337993.CODE_VALUE_10 in (‘CW’, ‘CW-ES’, ‘GEH’, ‘GES’) then T337993.RESOURCE_OBJECT_ID end ) as c3,
concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME) as c4,
nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’) as c5,
nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’) as c6
from
W_RESOURCE_D T337993 /* Dim_Resource_RM */
where ( T337993.ACTIVE_FLAG = ‘Y’ )
group by concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME), nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’), nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’))
select cast(NULL as NUMERIC(9, 0) ) as c1,
cast(NULL as NUMERIC(9, 0) ) as c2,
cast(NULL as NUMERIC(9, 0) ) as c3,
case when D1.c3 is not null then D1.c3 when D2.c4 is not null then D2.c4 end as c4,
case when D1.c4 is not null then D1.c4 when D2.c5 is not null then D2.c5 end as c5,
case when D1.c5 is not null then D1.c5 when D2.c6 is not null then D2.c6 end as c6,
cast(NULL as NUMERIC(9, 0) ) as c10,
D1.c1 as c11,
D1.c2 as c12,
D2.c1 as c14,
D2.c2 as c15,
D2.c3 as c16
from
SAWITH0 D1,
SAWITH1 D2
where ( nvl(D1.c3 , ‘1’) = nvl(D2.c4 , ‘1’) and nvl(D1.c3 , ‘2’) = nvl(D2.c4 , ‘2’) and nvl(D1.c4 , ‘1’) = nvl(D2.c5 , ‘1’) and nvl(D1.c4 , ‘2’) = nvl(D2.c5 , ‘2’) and nvl(D1.c5 , ‘1’) = nvl(D2.c6 , ‘1’) and nvl(D1.c5 , ‘2’) = nvl(D2.c6 , ‘2’) and D2.c3 0 )
order by c11, c12, c4, c6, c5

—————————
QA Physical Query
SAWITH0 AS (select count(distinct case when T337993.CODE_VALUE_10 in (‘GEH’, ‘GES’) then T337993.RESOURCE_OBJECT_ID end ) as c1,
count(distinct case when T337993.CODE_VALUE_10 in (‘CW’, ‘CW-ES’) then T337993.RESOURCE_OBJECT_ID end ) as c2,
count(distinct case when T337993.CODE_VALUE_10 in (‘CW’, ‘CW-ES’, ‘GEH’, ‘GES’) then T337993.RESOURCE_OBJECT_ID end ) as c3,
concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME) as c4,
nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’) as c5,
nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’) as c6
from
W_RESOURCE_D T337993 /* Dim_Resource_RM */
where ( T337993.ACTIVE_FLAG = ‘Y’ )
group by concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME), nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’), nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’)),
SAWITH1 AS (select distinct T337993.CODE_VALUE_08 as c1,
T337993.PRIMARY_ROLE_NAME as c2,
concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME) as c3,
nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’) as c4,
nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’) as c5
from
W_RESOURCE_D T337993 /* Dim_Resource_RM */
where ( T337993.ACTIVE_FLAG = ‘Y’ ) )
select cast(NULL as NUMERIC(9, 0) ) as c1,
cast(NULL as NUMERIC(9, 0) ) as c2,
cast(NULL as NUMERIC(9, 0) ) as c3,
case when D1.c4 is not null then D1.c4 when D2.c3 is not null then D2.c3 end as c4,
case when D1.c5 is not null then D1.c5 when D2.c5 is not null then D2.c5 end as c5,
case when D1.c6 is not null then D1.c6 when D2.c4 is not null then D2.c4 end as c6,
cast(NULL as NUMERIC(9, 0) ) as c10,
D2.c1 as c11,
D2.c2 as c12,
D1.c1 as c14,
D1.c2 as c15,
D1.c3 as c16
from
SAWITH0 D1,
SAWITH1 D2
where ( D1.c3 0 )
order by c11, c12, c4, c6, c5

Please let me know why it is generating different query and its generating huge temp files.

Reply

Pavithra

April 18, 2014 at 5:34 am

Hi Shiva/All,

I have a time series line view which contains many graphs, one for each departments. They all come one below the other. I am required to place two or three in first line,the next two or three in the second line and so on. I could not align the graphs side by side.Could you please help?

Thanks,
Pavithra

Reply

Neel

April 23, 2014 at 6:53 am

Hi Shiva,

I have created a bar graph in OBIEE 11g, and when try to add one more bar graph view in the same report ,its showing a selector in the Graph.

My requirement is i don’t want the selector in that.
Could you let me know your thoughts on that.

Thanks
Neel

Reply

swapna

April 29, 2014 at 10:36 am

Hi Siva, I want to Calculate Time diff in Seconds between 2 columns based on that I want to derive my Measure columns. My 2 columns are of TIMESTAMP Data type and when I use Second function in Answers its working fine where as if I define it in RPD Its throwing errors like non of the fact tables are compatible etc… I ve used SECOND(Timestamp Column 1) – SECOND(TimestampColumn 2) at logical expression. Similar issue when I use TIMESTAMPDIFF..
Please let me know ASAP.
THanks in Advance
swapna

Reply

Srinivas

May 5, 2014 at 7:46 am

Hi Shiva, While OBI Apps 11g installation and configuration trying run below .sql command.

sqlplus dev_biacomp/welcome1 @C:\Middleware\Oracle_BI1\sdf\DW\ATGPF\sql\fndtbs_11170_upg.sql

Missing the below directory….
ATGPF\sql\fndtbs_11170_upg.sql

Probably it is not created while DW….

Please suggest.

Regards
Srinivas

Reply

andres068Andres

May 7, 2014 at 5:56 am

Hi Shiva,

Good to know you.
I have a question about OBIEE write back function.
Currently, we can insert sentence in database by write back function.
Do you know is it possible to insert a paragraph by write back function?

Best Regards,
Andres

Reply

mrajeev233

May 22, 2014 at 1:45 pm

Hi All,

After Uploading ‘rpd’ file into Enterprise Manager server(EM),it is showing that BI server is down.If I click restart button in Enterprise Manager application,I am getting the same problem.This problem is occurring at the time of deploying RPD file into EM server.Please help how to deploy successfully.

Thanks in Advance.
Rajeev.

Reply

mrajeev233

May 22, 2014 at 1:58 pm

Hi All,

This is Rajeev.I am new for OBIEE tool and i have posted my issue in above .Please help on this.

Reply

Suresh

May 27, 2014 at 6:21 am

Hi Shiva,
I have upgraded obiee from 11.1.1.6.6 to 11.1.1.7.1 after upgrading, the report values are mismatched.can u pls help me on this.
Thanks,
Suresh.

Reply

tavneer

May 27, 2014 at 7:22 pm

Can we add note collumns in an obiee report where the users can update and save comments if they want to, so that the next time any one see the report they can see what was the latest comment or note left in the report

Reply

joan.bernardi

May 28, 2014 at 7:29 pm

We have OBIEE 11.1.1.7.140225 version. When downloading a report (both table or pivot view) to excel 2007+, the last row of the report is coming through as a merged cell. Any way of eliminating this row, other than manually deleting it in excel.

Reply

Ajit

May 29, 2014 at 7:26 am

Hi Shiva,
I have two pivot tables with total (horizontal). I wanted to show difference between this totals. how can I achieve this in OBIEE 11g

Reply

Reeta

June 3, 2014 at 8:04 pm

Hi Siva,
I have upgraded OBIEE 11.1.16.7 to 11.1.1.7.0 and Essbase Suite is missing. is there any way i can just install Essbase suite only in my existing OBIEE 11.1.1.7.140225. how is there any steps available? will it disturb existing OBIEE?

Reply

Sreejith

June 5, 2014 at 6:54 am

Hi Shiva,
I am using a field in OBIEE which returns a numeric value of 0.34. And when I round this off to a single decimal point it returns 0.3 as expected. But when I export this into a powerpoint thru OBI Office plugin, the value was displayed as .3, the 0 before the decimal gets omitted. As a work around, I tried using the CAST function inside OBIEE to return this value as a text so that the 0 will be in place. But then I use the ROUND function inside the CAST function to round off the decimal to 1 digit and then converting it to text, it’s returning 0.30 as the result. I am not sure why there are 2 digits after the decimal even if i use ROUND function to trim it to 1 digit. Can you please help?

Reply

sunil

June 12, 2014 at 5:43 am

I have a requirement like this. I have a report that report is Direct Database request. I want to pass the multiple values from the prompt in to the Direct database request report.

The single values is already passed in the direct database report with this syntax (@{PresentationVariable Name}). But when i tried to select multiple values from the prompt it doesn’t work.

So can someone have any idea or any workaround how it can be achievable. My version of OBIEE is 11g.

Reply

Shrikar Kondepudy

June 17, 2014 at 11:16 am

Hi shiva,

I am a newbie to OBIEE. I am confused in creation of LTS and heirarchial rollups.
Please let me know what are the various scenarios where there is a need to create a LTS.
Also some information about creating a heirarchial rollup for e.g. year>>half year>>quarter>>month>>date.

Reply

Vidya

June 26, 2014 at 7:27 pm

Hello Shiva,

This is my situation. My numerator is coming from one analysis and my denominator is coming from another analysis. Unfortunately I cannot try to retrieve both in the same analysis due to certain restrictions with the way the model was set up. Is there any way I can retrieve the monthly numerator from one pivot table, then retrieve monthly denominator from another table and calculate the rates….

The other workaround I can see is writing a SQL statement through OBIEE… which seems complex… any suggestions??

Reply

Prabu

June 27, 2014 at 10:33 pm

We are using OBIA 11.1.1.7.1 , when we try to configure implementation project in Functional Setup manager(FSM) we are facing issues. when i click the task lists its throwing a portlet procedure error.

On reading an Oracle document (Doc ID 1634973.1) i followed the steps mentioned in it, and it is throwing another error ,when i am trying to run a script(as per the document).Kindly let me know what can be done or where i am lagging.

Regards,

Reply

Leonardo

July 3, 2014 at 2:47 pm

Hi, I’m getting an issue on OBIEE 11.1.1.7 with Essbase 11.1.2.2.
The essbase cube was restructuring, then it was out of access for users. I opened the obiee dashboard and got an error on the analysis. The automatic selection of the combo month didnt work, then it showed a lot of graphs. Ok the cube was down. not big deal.
The big problem is, even after the cube is up, the analysis continuous with the same problem. Still get no selected month and a lt of graphs… Any idea? Could it be cache? This cache is for user?

Reply

Suresh Kumar

July 3, 2014 at 3:36 pm

Hello
Can you please help me ? I have an issue in OBIEE 10g (10.1.3.4.2). There is a date column in BMM layer in the format DD-MON-YY HH24:MI:SS. Now I need a new column with the format YYYY / MM by deriving from the date column. How to do that?

Reply

Dinesh

July 17, 2014 at 1:43 pm

Hi Shiva,

Where do I get the RPD and Data dump for OBIEE Sample App v406?

Regards,
Dinesh

Reply

Kannappan

July 18, 2014 at 7:23 pm

Hi Shiva, I have a question on creating marketing segment.

We are using Siebel Marketing 8.1.1.8 and OBIEE 11.1.1.7.1.

We have created an analysis using UNION operator in OBI Answers and trying to convert the analysis into segment using Create segment view option. But the create segment view is not showing the relevant Target levels for this union report. At the same time the segment view is working fine for single report without union operator. I am able to create segment from single report using create segment view. But not working for UNION report. Do you have any idea if this is expected behavior of Create segment view?. I would appreciate if anyone share your thoughts for how to create segment from UNION reports in Answers instead of creating segment with same criteria again in segment designer.

Reply

Archana

July 29, 2014 at 7:22 am

Hi,

I am getting the below mentioned error on my report after upgrading the OBIEE application to 11.1.1.7.14 version from 11.1.1.6.5 in the older version the report is working fine.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14023] None of the fact sources for Dim – Date Fiscal Calendar.Fiscal Year are compatible with the detail filter.

Please suggest resolution.

Thanks in advance.

Reply

Balaji

August 11, 2014 at 2:17 pm

Hi Shiva, can we have the Netsuite data on OBI Dashboard, if yes, please let me know the Step by step process.

Reply

Rk

August 19, 2014 at 11:45 am

HI shiva , we got a derived column in a dim (d1) and in its fx we use a column from another dim table.(d2) It is throwing error in 11.1.1.7 when pull alone this column with out fact columns joining these two dim . we can’t map the fact & dim (d2) in the. LTS of dim(d1) as this is joined with many fact tables. can u suggest a fix for this .

Reply

Kumar

September 1, 2014 at 7:52 pm

Hello Shiva,

There is a requirement to create a report.
Lets say I have a region table.. columns in region tables are(Area, Geo market, sub geomarket, sub sub geomarket, country).

if I select AREA in the view selector then I should only see AREA and GEO MARKET (its next level)
If i select GEO MARKET then I should be able to see only GEO MARKET and SUB GEO MARKET( its next level) , soo on
Can you please suggest me how to create this report.

Appreciate all your help on this and thanks in advance.

Regards,
Kumar

Reply

ravi Patel

September 10, 2014 at 6:06 pm

Hello Shiva,

I am trying to display 6 months of data from the current date. How would I go by doing that?

Thanks,
Ravi

Reply

Durga

September 15, 2014 at 3:01 pm

Hi Shiva, We have a static text that displays vertically in our report. So when we try to print as pdf the vertical text is coming as horizontal only. Could you please suggest what could be done for that?
The html that we have used is -(works in ie11 only)

.vertical-text
{
transform: rotate(-90deg);
transform-origin: 50% 50%;
}

XXXXYYYYZZZZ

Thanks in advance

Reply

Vinod Kumar

September 18, 2014 at 9:21 pm

How to highlight a change in data inside a report.
Example : (Yesterday) Day 1 , i have account 1,2,3 and 4 with few transactions posted.
(Current Date)Day 2 : I have to highlight only account 2 , where i have few more transactions on the day 2 , rest of the transactions on account 1,3 and 4 stays same.

Reply

Ravi Teja

September 22, 2014 at 4:59 pm

HI Shiva, I installed obiee on windows 8 and everything worked fine, but the admin tool pops out after 30 mins, Did anybody experience this problem?? pls help, I have a laptop situation mine is touch screen so i cant install windows 7 on mine. if any solutions pls mail me to doppalapudiravitejaa@gmail.com

Regards
Ravi Teja

Reply

Manoj

September 23, 2014 at 12:13 pm

Hi Shiva,

I am a newbie for OBIEE just started creating physical layer using the schema SCOTT with the tables EMP, DEPT and SALGRADE.

The problem am facing here is with joins. Am able to create Equi join between EMP and DEPT table. But when i try to create complex join between the tables EMP and SALGRADE, i have given condition as SAL>=LOSAL and SAL<=HISAL and click on finish it creates a complex join. But when i select the join diagram, there is no indication for joining between EMP and SALGRADE. Instead of that, i can see only the line between the two tables but that doesn't meant for join as like equi join between EMP and DEPT table. Could you please let me know, whether i have doen anything wrong here or need to do any settings in OBIEE 11g tool. You help will take me to next step of learning in OBIEE.

Thanks,

Reply

Nicola

October 2, 2014 at 1:46 pm

Hi Shiva,

my goal is to change ‘database’ and ‘physical schema’ in physical tables defined in a Logical Table Source. I cloned both database and physical tables on physical layer that subject area on business layer. I need to set the cloned database on the cloned logical tables. The only way I Know to do that is remove phisycal tables from logical table source and then adding the new tables paying attention to set the corret joins. After these operations, however, I lose the column mapping and all the calculated fields.
Remapping all fields and restoring all the calculated flieds it’s a very long and boring work.

Do you know another way to do that faster and avoiding errors?

Regards,
Nicola

Reply

Shiva

October 6, 2014 at 5:21 pm

Any ide provide any info on a Sorry Page that Finance subject area can use for OBIEE Self-Service Dashboards. We would like for this page to display automatically when the Finance subject area OBIEE Trail is delayed past 8:00 AM EST.

Reply

Nanda

October 7, 2014 at 9:15 pm

Hello Shiva,
Recently we upgraded OBIEE from 11.1.1.6 to 11.1.1.7.0. LDAP accounts are not getting authenticated. We come across this issue
An error message was received from the BI Security Service: oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed – the system user profile could not be found in the identity store.
[2014-10-07T16:45:54.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0001JlxPA5l03zgkDCV4Fw0002rH000000] [tid: 77] [nQSError: 13049] User ‘BISystemUser’ with ’empty’ permission can not query user population.

We have Oracle system user and BI system user as “Default authenticators” thats how it was working in 11.1.1.6. But after upgrade it constantly keeps failing with this message.

Any ideas? Do we need to have Oraclesystemuser and BIsystemuser as LDAP accounts?

Reply

Lokesh

October 9, 2014 at 11:26 am

I need to find the data for current week, last two weeks, last three weeks, last four weeks…last 12 weeks. I can’t use this formula: FILTER(“Service Request”.”DT” USING (“Time”.”Week” = CONCAT(LEFT(VALUEOF(“CURRENT_WEEK_OBIA”), 9), CAST(CAST((WEEK_OF_YEAR(CURRENT_DATE)) AS int) AS varchar(2)))))
ERROR: Function FILTER requires at least one measure column in its first argument.
Please reply ASAP.

Reply

Abhijeet

October 9, 2014 at 6:16 am

Hi Shiva,
Kindly suggestions my requirement is 1.Integration of Peoplesoft 9.0 and OBIEE 11g.
2.OBIEE 11g: Authenticating to OBIEE 11g With Users in LDAP, Groups in Database . also
I could not find DOC ID 1428008.1 on MOS.

Thanks in advance,
Abhi

Reply

vasu

October 10, 2014 at 3:37 am

Urgent help
I need case statement for create the reports for each month’s ytd through a case statement.

Reply

Suresh

October 10, 2014 at 7:30 am

case when Date.”Report Year”=2014 and Date.”Report Qtr”=4 then 1 else 0 end
it will display 4 qtr of data means each qtr having 3 months so tatally 1 yr data u will get it…
Hope this will help you..

Reply

iswarya nandini

October 13, 2014 at 7:16 am

Hi All,

My requirment is to limit only last 5 yers of data from flowing into Reports from an OBIA vanilla rpd.

I read that i should apply calendaryear>2008 filter in BMM content level.

Can you please confirm where all i should place this condition?..

Regards,
Ishwarya

Reply

Sai

October 14, 2014 at 2:36 pm

Hi Shiva,

I need to display a metric column value as single line on top of analysis, for ex: I have fact column with 176 value , I should display this on top of analysis, saying that number of pieces are 176.

How can i do this? I tried with Narrative view, this is only working for attributes, not for metrics, pls help.
Thanks,
Sai

Reply

Pavan

October 14, 2014 at 3:47 pm

Hi shiva,

I have couple of questions regarding on cluster environment.

we have a 4 node cluster environment and node1 and node2 are configured for failover in EM as primary and secondary servers.

Q1.Now my problem is when I bring down primary and secondary servers, I was unable to login to the other 2 instances. Its throwing invalid username/password error.

Q2. I dont see scheduler and cluster component on the other 2 instances.

Q2. I am rebooting the entire BI Application.

Here are the steps I am following to bring the application up. Please let me know if I am doing it the right way. My question is should I start the weblogic on all the instances are just on the primary instance.

1. start weblogic on node1
2. start node manager node1, node2 ,node3 & node4
3. login to EM and start the managed servers bi_server1, bi_server2, biserver_3 & bi_server4t
4. finally start all the components.

Appreciate your help

Thanks,
Pavan.

Reply

debasis rana

March 17, 2015 at 9:49 pm

Hi Debasis here Shiva,
First page in Obiee will show 2000 rows its ok but if we click next button it will show more 10000 record how to configure that in obiee .please reply

Reply

Deepak

October 30, 2014 at 9:39 am

Hi all,
How can I calculate current day- 61 days back total sales.I mean I want total sales only on that particular day.Similarly I want current week – 2 months ago week total sales.Can anyone please help me.

Reply

Madhusudan

November 8, 2014 at 7:13 pm

Not able to update columns with null by write back in OBIEE 11.1.1.7.1

Reply

Poornima

November 11, 2014 at 10:45 am

Hi Shiva,
I am trying to handle null by using RPD physical layer. I have deselected Nullable. But it is not working. Any clue ?

Thanks & Regards,
Poornima

Reply

Paresh

November 19, 2014 at 2:03 pm

How to stop dashboard Apply button from form submission.I need to throw some some custom exceptions on validations.

One approach is: I hide Apply button and create my own button and onClick: return false –> But this approach will require all my dashboards to have this PLUS i need to write required fields validaitons for this newly created button

Is there any smarter way??

Reply

chanduabbavaram

November 28, 2014 at 10:24 am

Hi,

Prerequisites:-

1) XE Data base Installation
2) ODI 11g Installation
3) RCU Creation
4) OBIEE 11G

Is there any thing Sequence for install this software’s in windows 2008

Thanks & Regards,
Chandra

Reply

sumanth

December 11, 2014 at 5:09 am

Hi Shiva,nice to meet you.I have few questions on OBIEE Clustering.When I migrate catalog folders from dev to qa ,should I have to migrate those folders to both URL’s bec some times some reports are dissappearing.pls contact me at 4088964426 or sumanth.pandilla17@gmail.com.

Reply

Renu

December 30, 2014 at 12:31 pm

Hi Shiva,

How to pass parameters dynamically while scheduling analysis report in obiee (OBIEE 11g)?

Please provide the solution for this.

My Scenario:
I have schedule the Analysis Report by using Agent but in content tab it choosing the analysis path & name and i am not finding any option to set the parameter.
Here i have to set the parameter while scheduling the Analysis report.

Please suggest me!!!!.

Thanks
Renu

Reply

Prajna

January 29, 2015 at 6:18 am

Now I am facing a problem with componet which is belongs to Oracle ADF Techonology.
In Ring Graph ,I have to display the Service Type in slice of the pie. The thing is in ring pie the total count of service type is
showing in center means in that hole part as total. I want to remove that total count from center and need to display in bottom of the
pie Graph. I want to add Zoom functionality in graph .On Button click it should zoom on .Can You guide me How to do.

Reply

chowdary

February 3, 2015 at 10:46 am

Hi Shiva,

i need a small help from you regarding timestamp

My requirement is need to display territory and bottom5 records, need to get bottom 5 values from current year and previous year measure variance data.
Filters->> order year order month name and ship date> order year 2014 order month name January shipdate> order year 2013 order month name January shipdate<=01/31/2013 12:00:00 AM
From both the current year and previous year measure need to take the difference and need to apply bottom 5 on variance

Reply

Naveen Kumar

February 8, 2015 at 4:04 pm

Hi shiva. i am using obiee 11.1.1.7.0 version. everytime i start all services.i am getting the below warning.
can u please send me the solution

Reply

Gokul

February 25, 2015 at 9:20 am

Hi Shiva,

I have 2 repositories and couple of reports in the catalog path. Is there a quick way to identify or group the reports belonging to each rpd ?

Reply

Abhilash

February 26, 2015 at 10:55 am

Hi Shiva,

I am unable to Open front-end Analytics on Safari & Firefox(MAC system).
OBIEE version is 11.1.1.7.140.
Server which have SSO configured is unable to access.
Error: 401 Unauthorised.

Please let me know if you can help me on this.

Thanks,
Abhilash.K

Reply

HARI KRISHNA

February 27, 2015 at 9:42 am

Hi Shiva,

How do I save OBIEE (11.1.1.6) analysis in CSV / XML file into Linux shared folder automatically on daily basis ?

Appreciate all your help on this and Thanks in advance.

Regards,
Hari Krishna

Reply

Abhi

March 1, 2015 at 11:48 am

Hi Shiva,

I am consuming OBIEE web services using java. I want the path of all analysis and prompts associated with a dashboard that a user selects. I am able to fetch all the dashboards of a BI application using WebcatalogService in OBIEE(by using the getItemInfo and getSubItems methods) .But I am not able to get the details of objects associated with that dashboards like analysis and prompts. Can we get the information of which analysis are associated to a dashboard and their paths ??

Kindly help,
Thanks

Reply

Abhi

March 3, 2015 at 6:44 am

How to insert multiple columns in a single dashboard prompt

Reply

Anjaiah

March 6, 2015 at 9:53 pm

Hello All,

i am applying patch on obiee11g on windows 64 bit but getting below error.please help on this.

“unable to lock central inventory. opatch will attempt to re-lock. do you want to proceed in?”

Thanks,
Anjaiah.

Reply

Ravi

March 12, 2015 at 1:45 pm

Hi Siva,

i have below requirement how to achieve this.

Is it possible to change the functionality that during an OBIEE REPORT
export the dot becomes a comma ?

Reply

Snehal

March 14, 2015 at 7:41 am

how we can call procedure using obiee 11g reports????please guid me in detail with steps…thnaks

Reply

goutham

March 18, 2015 at 1:20 pm

Hi Shiva,

Check Interaction between the Dashboards is not working properly. When i click back Main page , all reports are showing no results.—please suggest

Regards,
Goutham

Reply

goutham

March 18, 2015 at 3:42 pm

Hi shiva,

Interaction between the Dashboards is not working properly When i click back Main page , all reports are showing no results.please help

Thanks,
Gowtam

Reply

Aarti

March 25, 2015 at 9:47 am

Hi Shiva,

I need one help in obiee 11g.I want to provide distinct join condition in physical layer of repository.Is there any way to provide this ?

Please suggest something.

Thanks.

Reply

hadi

April 9, 2015 at 1:20 pm

Hello shiva,

I work on obiee 11g and i need to know if there is a way to get the physical table name from the alias name, same for the columns.
Is there any built in functions to return this ?

Reply

aditya

April 14, 2015 at 5:46 am

Hi Siva,
Can we have the option to track number of downloads for reports/dashboards in obiee 11g using usage tracking.

thanks
Aditya

Reply

karnati

May 8, 2015 at 9:45 am

Hi Shiva,

I have requirement like this(using 11.1.1.6.12) …After the user selects the dashboard prompts and apply button,Instead of running the request It should ask to save the results

Can you please let me how can we achieve this
Thanks in advance

Reply

srini

May 12, 2015 at 2:18 am

Hi Siva,

I really need your help on the Row level security Implementation in Table level.

I have requirement as below.
When user login to OBIEE11g, should restrict data based on the Access_ID
Customer table table
Access_code Security level
123456 1
345687 0
USER TABLE
username security approval level
abc 10
xyz 102
ghk 1

I have restrict the access_code based on the User – security approval level.

For ex : Any user trying to access the customer table it should restrict the access_code based on the security level of access_code and security_approval level.

please guide me how can we do this.?

Reply

jaahnavi

May 12, 2015 at 9:58 am

Hi Shiva,

We have manually deployed a 50MB rpd using Mbeans technique, The deployment was successful, but when I try to create the report, the columns in subject area are not loading, I have waited for 3-4hrs but still it remains same.

Reply

Raj Laxmi

May 13, 2015 at 10:11 am

Hi Shiva,
I need to have an ” TOTAL row ” for a particular column after each column’s value.
Also the name “Total” for each row should be shown as ” sum ”
ex: heading1 heading2 subhead fact_value
————————————————-
XYZ ABC p 10
XYZ ABC q 20
XYZ ABC sum 30 —this is “total row” for heading1 = XYZ
PQR DEF p 40
PQR DEF q 50
PQR DEF sum 90 —this is “total row” for heading1 = PQR

value to be repeated i.e ABC to come and for “subhead” column “Sum” to be come and a total value under fact_value.

Reply

krishna

May 25, 2015 at 10:12 am

Hi Shiva,
i want to know about same qn Raj Lakshmi

1) About total,subtotals for every column .
2) About GL Reports scenarios…any

Reply

Anand PS

May 26, 2015 at 5:00 am

Hi Shiva, We have added a new column to an existing table ‘ABC’ in database. When we pull this column to a report along with other columns from an MV then data is missing for another column in table ‘ABC’. Our team checked all joins and content side.. but not able to find the root cause…

Reply

Abby

May 28, 2015 at 9:06 am

Hi, what should your data look like if you want to create a time dimension in OBIEE 11g?
For example, should I create a column for year, month, date like:

year | month | date
2015 | Jan | 1
2015 | Jan | 2
.
.
.
2015| Dec| 31

or should I have a ‘tag’ and a value like:

Thanks for your reply

Reply

Shiva Molabanti

June 14, 2015 at 3:50 pm

Hi Abby,
You can go with just values in columns and doesn’t need to have the tags.

shiva

Reply

Sai Kumar

June 10, 2015 at 5:57 pm

Hi Shiva,
Is there anyway that we can customize no result view message dynamically as per subject area for all reports.

Reply

Shiva Molabanti

June 14, 2015 at 3:31 pm

No Sai. It is just a static view to customize and cannot be based on dynamic varies

Reply

ANil Kumar

June 11, 2015 at 1:35 pm

Hi Shiva,

i need your expertise on one of the requirement i came across.

Deprecate ‘X’ attribute (attribute should still work for existing reports, but be hidden to prevent users from including it on new reports).
I tried with hide if object and coloumn level security,no luck.

I can hide the object but iam not getting results in the existing reports with the X column.

Thanks
ANil

Reply

mahmoud

June 15, 2015 at 4:28 pm

Dears,

I am so tierd and still looking for soluation

how I can perform the relod time in administration tool in OBIEE to

apply the real time approach (two sources physical tables(OLTP/EDW) in one logical table)

pls support
ora_deve@yahoo.com

thx

Reply

Kannappan

June 16, 2015 at 2:53 pm

Hi Shiva

I need your suggestion on the following issue.

We are using OBIEE 11.1.1.7

I keep getting the following error when trying to run a query only on Dimension columns in OBIEE Answers:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request Dim…

I have the following setup in RPD.

Physical layer:
I have 2 fact tables and three dimensions. Both facts are fact-less tables. ie. no measures, only Foreign key of dim WID is populated in fact tables.

F1 <- D1, D2
F2 D1, D2
F2 -> D2, D3

I created dimension higherarchy for each dimension table with two default levels –Total and Detail.

Content levels are set up in logical fact as follows:
F1: D1=Detail, D2=Detail, D3=Total
F2: D1=Total, D2=Detal, D3=Detail

Also I have set Level based measures in the fact.ie. Total levels for Non-confomred dimensions.

F1.x is setup as implicit fact column (dummy measure).

Now I want to generate a report only on dimension columns ie. D1.x, D2.x and D3.x. I dont need any Fact. It throws the above error. If I add any one of fact column, the query works fine. But end user will generate most of the adhoc reports using dimension columns only.

Please suggest if my logical data model is correct and also I am wondering how the answer query is working fine when any of the fact measure is added explicitly, but not working with implict fact column (same fact column is added as implicit fact).

Doesn’t Implicit Fact work with Non-Conformed Dimensions? If Yes, what is the best approach to make it work?

Please help me to fix this issue.

Reply

Kannappan

June 16, 2015 at 2:56 pm

Oops! some lines are missed in my comments.. Here is my RPD setup.

Physical layer:
I have 2 fact tables and three dimensions. Both facts are fact-less tables. ie. no measures, only Foreign key of dim WID is populated in fact tables.

F1 <- D1, D2
F2 D1, D2
F2 -> D2, D3

I created dimension higherarchy for each dimension table with two default levels –Total and Detail.

Content levels are set up in logical fact as follows:
F1: D1=Detail, D2=Detail, D3=Total
F2: D1=Total, D2=Detal, D3=Detail

Also I have set Level based measures in the fact.ie. Total levels for Non-confomred dimensions.

F1.x is setup as implicit fact column (dummy measure).

Reply

ram

June 29, 2015 at 2:29 pm

Hi Siva/All,

I have a requirement on agent/Ibot which shoud trigger an email to the business users. I had created one agent with condtion on the agent.If condition satisfies it should trigger an email. Upto here ok.

I want to stop an agent once the conditon is met .

Could you please give your inputs on this please.

Looking forward.Please let us know if more information is required.

Cheers,
Ram

Reply

Indu

June 30, 2015 at 7:39 pm

I have a requirment ,if u user selects year-quater as 2014-Q2 in prompt ,graph should show last 3 quarter data like 2014-Q2,2014-Q3,2014-Q2 data.could you please help on the same.

Reply

Rapunzel

July 7, 2015 at 2:20 am

Hi Shiva,
Do you have any prior experience in integrating OBIEE with JD Edwards application. I would like to create some gauges/charts etc in OBIEE and integrate it into the JDE forms, in order to display it interactively for the user. i am using parameter driven data model for the same.
Appreciate you response.

Reply

KiranK

July 10, 2015 at 11:01 pm

Configure E-Mail on ETL Failure or Sucess with BI Applications 11.1.1.9.2

Reply

KiranK

July 10, 2015 at 11:04 pm

Hi Siva,

Do you have any ideas or configure E-Mail on ETL Failure or Success, Which we had in 7.9 + Version in DAC. How to we accomplish this with BI Apps 11.1.1.9.2 Version

Thanks,
KK

Reply

samba

July 18, 2015 at 9:24 am

Hai Shiva,

I have a problem to save and check in changes in my RPD in online mode,
” nQSError: 37005 Transactional Update Failed ” error will be came.
why this error will be came and how to solve this issue?

Reply

Shiva Molabanti

September 28, 2015 at 8:22 am

Check your DB connection. Make sure to have the tables that you are trying to update.

Thanks,
Shiva

Reply

Santhosh Sreshta

July 29, 2015 at 9:44 am

Hi Shiva,

I am very new to this software, Please enlighten me in , how to get the work repository details in ODI Console.

I have developed some interfaces in ODI studio, later I have opened console, there I am unable to view the details of the work repository which I have created in ODI Studio.
Is there any procedure to get those details in the console.

Thanks a million,
Santhosh.

Reply

Chakravarthy yadav

August 13, 2015 at 7:09 am

Hi Shiva,
Is it possible that we pull live data from source DB when I run a OBIEE report.
Thanks,
Chakri

Reply

Bhagz

September 6, 2015 at 7:34 pm

1 table is aggregated another table is not aggregated and report is ran using these two tables….hw wud we achieve this with out making performance low

Reply

Pankaj

September 7, 2015 at 7:04 am

Hi, we need to use a database function in OBIEE 11g.
The function is in package eg (package.fucntion name).
We are using EVALUATE function to call our function, EvaLUATE syntax we are using is.

EVALUATE(package.function(%2) as number, subjectarea.table.column1, subjectarea.table.column2)

please help[

Reply

Serg

September 21, 2015 at 2:47 pm

hallo! How to do double the results in analys? First row – sum, the second – average. The option for rule aggregation at the level of the repository will not work in this particular case.

Reply

Saranya

October 21, 2015 at 6:25 am

Hi Shiva,

I need some help in getting the below logic :

Requirement : User passes business date from calendar prompt (uses BETWEEN operator) from dashboard.
we need to get the difference between these 2 dates and pass in the report for a particular column calculation.

I tried the below but not working:
TIMESTAMPDIFF(SQL_TSI_DAY,TIMESTAMP’@{from}’,TIMESTAMP’@{to}’)

from & to are presentation variables as i need something like below

Eg : TIMESTAMPDIFF(SQL_TSI_DAY,TIMESTAMP’2015-10-15 00:00:01′,TIMESTAMP’2015-10-16 11:59:59′)

Please share your suggestions.

Thanks,
Saranya

Reply

Wayne

November 3, 2015 at 6:32 pm

Hello Shiva,

So I have a bi publisher report that has 2 parameters. My sql pulls data in the report so all is good there. I have a table that I modify ar_app_data that I use to put sql so the web page will pull the parameters and let the end user pick what they want in the Parameter. So why would it work in the actual report but one of the parameters do nothing but spin and not return data?

Reply

Pradip

November 5, 2015 at 9:43 am

HI Shiva,

I am facing below error after OBIEE upgradation from OBIEE 11.1.1.7 to OBIEE 11.1.1.9

” View Display Error
A subquery filter may not reference the current report (or contain a circular reference to any report).
Error Codes: S6C66RYK:WIF3IYGO
Location: saw.views.evc.activate, saw.subsystem.portal.pagesImpl, saw.subsystem.portal, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

Recursion limit exceeded in Xml Expression Visitor

Do you have any idea how to resolve it.

Thanks in advance 🙂

-pradeep28186

Reply

AJ

November 19, 2015 at 10:11 pm

Shiva –

Can you please help me find a solution to run and schedule a BI Publisher report from a command line prompt or cron job?

Please! I need it real bad. You might have done this. Please send me a sample code dude!

Regards,
AJ

Reply

Eric Tremblay

December 4, 2015 at 8:24 pm

http://www.data-warehouse.ca/ODI_Expertise.html

Quick ODI question. I’m trying to figure out how many steps in a Load Plan before execution… I can figure it after but not before.

SELECT
I_LP_INST INSTANCE, MIN(TRUNC(START_DATE)) START_DT, MAX(TRUNC(END_DATE)) END_DT, COUNT(1) STEPS_EXECUTED_LOAD_PLAN
FROM SNP_LPI_STEP_LOG
GROUP BY I_LP_INST, NB_RUN, TRUNC(START_DATE), TRUNC(END_DATE)

Thanks

– Eric Tremblay

Reply

Nitin Joshi

December 29, 2015 at 9:23 am

we can use BIPCatalog utility to import existing report in BI Publisher in 11g. But How can we import those reports in 12c using same BIPCatalog utility ?

I am not able to found this utility in OBIEE 12c environment. Please guide me on that.

Reply

Sudhakar

January 8, 2016 at 5:56 am

Shiva, I want to disable drill on grand total in Table view, but drill should be there for the values. How can i disable either column level and row level grand total.

Reply

Ashish Jain

January 8, 2016 at 7:01 am

Hi Shiva,

I have one requirement of embedding BICS dashboard/reports in another application.
Is it possible?
In case of on-prem version, we can do using Go URL.
Can it be done in case of BICS as Go URL doesn’t work in case of BICS.
Is there any other way/approach through which we can see BICS generated reports/dashboards in other application or
HTML page (iframe)?
It would be great if you share any approach.

Thanks,
Ashish

Reply

Siri

January 23, 2016 at 3:51 pm

Hi,

We have a situation in our reports where they aggregate data for multiple months based on a year . How ever for period 2 in 2016 the report needs to run for January and December of 2015 . Is there a simple solution to fix them by just updating the session variables in dashboard prompts we use for accounting period and fis_year

Siri

Reply

Ram

January 25, 2016 at 12:18 pm

Dear
In mobile device iOS mobile HD, I’m getting authentication failed
Request time out (1001)

Please help

Reply

srikant

January 27, 2016 at 6:32 am

What all will be the impact on obiee when upgraded to 11g to 12c (in testing perspective)?

Reply

harshal pawar

January 27, 2016 at 11:52 am

hi shiva,

I have obiee11g installed and I try to create report in analytics link,

when I click on result tab , pop up appear ‘Not enough storage is available to complete this operation’

I have gone through log files but no luck,

Regards,
Harshal

Reply

harshal pawar

January 27, 2016 at 12:07 pm

hi Shiva,

I have obiee11 g,

when I open report from analytics link,

it gives pop up message “Not enough storage is available to complete this operation”

what will be the issue,

As I gone through log files but no luck.

Regards,
Harshal

Reply

mohan

February 3, 2016 at 8:25 am

Hi Team,

we have developed a report. in the pivot table last 3 columns data showing empty where as when we run the physical query data displayed in DB. Please help me out to resolve the issue

Reply

Amy Smoke

February 4, 2016 at 9:32 am

Hello Shiva

I need assistance in setting up multiple authenticators in OBIEE 12c. Our requirements:

1. Allow users to log into the system by one of two means
a. User id and passwords that are dB credentials (11g)
b. User id and passwords managed by the OBIEE default LDAP
2. All reports/dashboards are built utilizing the Answers tool
3. All reports are based upon RPD with shared connection
4. All authorization is managed through the OBIEE roles and user groups

I have created all user ids in the OBIEE LDAP. However, I’m unsure how to configure 1a so that the credentials essentially ‘pass through’ to the dB for authentication.

I also know that authenticators may be established with order of precedence. In this case, the dB credentials method should be resolved first, and the default LDAP authentication last.

Thanks in advance.

Reply

essbase

February 10, 2016 at 5:06 am

Hi Shiva,
In OBIEE analysis, I have Essbase data source . Sorting on Alias- member values on hierarchy eg. Gen-3 .. are not sorted in ascending or descending order. Any suggestion is appreciated.

Thanks

Reply

Pavan

February 19, 2016 at 2:40 pm

Hi Siva,

If possible, Can you how to get the below requirement in obiee11g.
We need below points:

1. future DB growth for next 3-6-12-18 month
2. See first 100 biggest tables and their growth during last 3 months
3. See each SCHEMA growth with comparison to other schemas and their growth for the last 3 months
4. See current snapshot on weekly basis with option to drill down for each day in selected week (for last 12 weeks) and drill down for each day to see by table

Thanks in Advance..

Reply

gopi

February 25, 2016 at 2:01 pm

Hi,
we have three obiee environments,prod,dev,test…all are clustered environments,data is matching in both dev and prod but not in test env, more number rows returned from the client in test environment, for example a report is fetching 43 rows in dev and prod, but in test 139,all the environments pointing to same db and connection pool also same,physical query generating is also same,but no of rows retutned to client is different…what is the possible issue in test environment…

Reply

bammidi

March 2, 2016 at 2:46 pm

i want to display custom message instead of write back error message in obiee report pls suggest

Reply

ravi kumar

March 4, 2016 at 1:06 pm

WHAT IS USE OF CHRONOLOGICAL KEY

Reply

manikanta

March 10, 2016 at 6:06 pm

Hi Shiva,

Is there any parameter to put time out limit or export limit for Agent?

Regards,
Mani

Reply

Shiva Molabanti

October 12, 2016 at 12:30 am

Yes Mani. You can set teh Timout seconds in the opmn.xml for delivers module.

Reply

Praveen

March 14, 2016 at 4:09 pm

Hi Shiva,

I am actually using filter of function in OBIEE front end.
for eg:
FIlter(“Facttable”.Metric_Column” Using (“Time”.”Month_name” IN (@{MONTH_NAME}{December}))).

In the answers it is working fine, when when i am running on the dashboard with the prompt value selected. it is throwing me an error.
Error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27045] Nonexistent column: “February”. (HY000).

Can you please help me out

Reply

madhurikharidas

March 21, 2016 at 6:11 am

Hi,

I have a requirement to publish the closing balance for every month for a given year. So for 2016, it will have columns Jan – Dec, showing closing balances from beginning of time to Jan end, in Jan.. Till Feb end in Feb and so on..

Could you please advise how to achieve this ?

Reply

Elavarasan

March 29, 2016 at 9:34 am

Hi Shiva..

please to meet you..i have small doubt in OBIEEtool..

After applying suppress option in all the columns i could see in some of the columns it’s not reflecting..can u please suggest me with some solutions.

Thanks & Regards
Elavarasan N

Reply

vamsi

April 18, 2016 at 4:54 am

hi shiva,
can u please tell me how get a pop-up msg report level(on column) in obiee 11g.
Help me to solve this one….

Reply

caner

April 20, 2016 at 1:47 pm

Hi,

I have a problem with obiee 11g. Users can log in to analytics with invalid username and invalid password even with no password. Can you help me! Where do I investigate about that or what you offer?

Please Help!
Regards,

CO

Reply

gopalakrishna

June 2, 2016 at 5:26 am

i have two columns actual and quoted ,another more column difference (quoted -actual) i want to highlight the value negative values with red color and positive values with green color.
can you please help me and give some steps to forward.
thanks & regards
gopalakrisha
8870799905.

Reply

Shilpa Reddy

June 4, 2016 at 3:07 pm

Hi Shiva,

can you please tell me what all i need to Install OBIEE 12c on my local PC for practice purpose ?
and what version of OBIA will supoort OBIEE 12C? i am going to buy a laptop for practice so can you suggest which configuration should i buy and which model is good with OBIEE

Reply

Nischal

June 23, 2016 at 5:03 am

Hi. I need help in scheduling a BI Publisher report, in a way that it dynamically identifies the recepient (To address) from an OIM table or a lookup, whichever is feasible. How can it be achieved?

Reply

Sandeep Andhale

July 5, 2016 at 7:20 am

Report of Fusion CRM application :-
Subject Area used :- Sales – CRM pipeline
Column Name :- Territory Name, Territory Quota

How to Hide parent level territory node report ?

Requirement is:- I want to see only child level territory row data inside the report

But currently showing all territory row inside the report

Thanksk & regards
Sandeep

Reply

Sandeep Andhale

July 5, 2016 at 7:22 am

how to suppress Territory row

Reply

Kumar Abinesh

July 21, 2016 at 12:28 pm

Hi Shiva, Is there any process by which discoverer reports can be migrated into BICS?

Reply

Anifa

August 7, 2016 at 1:20 pm

hi shiva my play store doesn’t work i tried to reboot.clear cache and data but its the same tell me aunthentication error you need to sign into your google account,but i tried to change my account but its not help ,,help me please

Reply

Sur

August 12, 2016 at 2:50 am

Hi Siva,

I have 2 report (summary report and Detailed report) in Bi HR App and a group of user can see the summary report while they are unable to see detailed report , please advice.

Regards
Sur

Reply

Sur

August 12, 2016 at 2:59 am

Hi Shiva,

I have BI HR App 10g where a group of users can see the summary report but when they drill down to detailed report they get “No Result”, please advice !!.

Regards
Sur

Reply

Shiva Molabanti

October 12, 2016 at 12:23 am

Make sure to grant Read permissions to the folder and report where you have saved the detailed report for that particular group. You can just grant read permissions to that particular report only.

Reply

Christin

August 26, 2016 at 6:17 am

Hi Shiva,

I have a problem with obiee11 g.When i tried to take data from two fact table(each are connected using dimension tables)it results empty data from second fact tables,The obiee query
doesnot considering the second fact table.

Christin

Reply

Shiva Molabanti

October 12, 2016 at 12:22 am

Make sure the common dimension table is set at detailed level in both the Fact table Levels in BMM.

Reply

Christin

August 26, 2016 at 9:54 am

Hi Siva,

Is there any problem for selecting values from two fact tables. I have two fact table one for order and the other for shipping.When i tried to take data from both it shows an empty list for the columns from second fact table(shipping). Both the fact tables are connected using more than one dimension table and still the problem remains.Could you suggest a solution

Christin

Reply

Saq

August 29, 2016 at 8:23 am

Hi Shiva ,

I have one requirement in BI-MAD11g ( 1.1.7.1 ) ,

* I would like to hide or disable Menu option from the apps ( Top Left side on ) ( Menu option : after clicking it we will get option like Page , Parameter etc )

* Is any way to write java code in BI-MAD ?

Reply

Shiva Molabanti

October 12, 2016 at 12:21 am

Yes There is BIMAD SDK. Folks are writing the custom plugins using it. You can control teh menu features in the custom plugin/report code.

Reply

Sadashiv

August 30, 2016 at 5:44 am

I have a problem with obiee11g. I have created report with drop down Table and Graph. In a dashboard default I kept as Graph. In a dashboard when I apply prompt year and month graph is not displaying after that I select table it is having data. After that If I choose Graph. Graph is displaying.

My question is why Graph is not displaying when I apply prompt?

Please Help!.

Best regards,

Sadashiv

Reply

Shahbaz Chanadrki

August 30, 2016 at 6:05 am

Hi,

I really liked your article about Data Lineage.
Is there a way to include the ‘UI Report’ and ‘UI Column’ name as well, because generally we tend to change those particular fields as per client request which doesn’t get tracked in the Catalog_Data sheet.

Thanks.

Reply

Shiva Molabanti

October 12, 2016 at 12:20 am

Do you store the UI Report & UI Column references anywhere in the Database per customer? How do you change it ?
Based on the references of the changes we can capture it eother from catalog or the source where you have that info.

Reply

Maheswaran

September 2, 2016 at 6:05 am

Hi,

I am creating a ah-hoc query based report and need to add filter parameter to the query allowing to retrive for all values when value is passed to the parameter if not particular value.
The issue her is NVL will not work ,when no value is passed it returns the presentation variable.can you help me

Reply

Indrani Sarkar

September 3, 2016 at 12:40 pm

Hi Experts,
I am having 800 dashboards and prompts in OBIEE. Post Deployment ,we need to run each dashboard and prompt individually to ensure its not facing any error.
Is there any way I can automate the process so that after deployment we can avoid the manual work of executing each of them one by one?Any method will do other than using third party software.
Please suggest.

Reply

Shiva Molabanti

October 12, 2016 at 12:18 am

1. try OBIEE 12c Base validation tool.
2. You can also try teh GOURL parameters. If the URL doesnt return any error, that means report passed (But you need to verify the results manually).

Reply

BI dev

September 22, 2016 at 7:53 pm

hi shiva,

i did create analysis with pie chart, for same criteria pivot table showing right percentages not pei charts not.
Did encounter this kind of issues

Reply

stewart

September 23, 2016 at 2:50 pm

When we run runReferenceChecker.sh we are getting an error:

~The char ‘0x0’ after ‘java.lang.NumberFormatException: For input string: “‘ is not a valid XML character.

Reply

Israel Elias

October 7, 2016 at 4:42 am

Hi,
We need to know is there a way to create interactive response reports, for example we need to have a bank statement, in the output, the client can play around with some value, lets say that the gain a credit so that can play with calculating there capital, the timing. Can it be posible on version 11,1.1.9 or either in 12c

Reply

Nakul

October 7, 2016 at 11:27 am

Shiva,
I have a request for new subject area build with the following functionality like when the user builds report.
->One should be able to select report data from Detailed data or aggregated data respectively.
so your thoughts and ideas on above query would highly appreciate.

Thanks,
Nakul

Reply

Shiva Molabanti

October 12, 2016 at 12:11 am

There are multiple ways to achieve this. One simple way that I am thinking now is: Create two logical table sources (LTS) in the RPD for each aggregated fact and detailed fact. And create a column like Run_Aggr_Flg or something and map this column to Aggregated table LTS only. Similary Create another Column as Run_detailed_Flg and map it to only Detailed LTS.

Now In the report add these two Columns: Run_Aggr_Flg & Run_detailed_Flg and add them two column selector and save it.

So that when you run teh report, you will see a drop down list two choose the columns. Based on the column you choose, OBIEE will send the Request to that mapped LTS.

Reply

T Johnston

October 7, 2016 at 8:29 pm

We are currently evaluating ERP/HCM and BI capabilities and are fairly close to selecting Oracle Cloud. I’m am a little confused about what the BI in the cloud offers. We already have Microsoft Power BI and I’m wondering if we really need BICS. What would we be losing if we did not subscribe BICS? Where/how are BICS reports/visuals surfaced? Will Oracle cloud users have to switch between ERP to another site to view reports published from BICS?

Thanks in advance for your advise!

Reply

Shiva Molabanti

October 11, 2016 at 11:54 pm

Yes Johnson. The BICS is a portal in the cloud. When you are integrating the ERP/HCM apps with BICS, The BICS will read the data from ERP/HCM apps directly and allows you to view the pre-built reports that comes with the package and also let you to create the adhoc reports for your business needs.

Reply

balaji mvn

October 8, 2016 at 8:35 am

Hi Shiva,

I am facing below error while doing the rpd consistency check.
kindly check and advice me.
ERRORS:

Business Model Odwt:
[15048] Logical table: Dim-Organization must be a descendant of the root logical table in the associated dimension, according to logical many-to-one join relationships.
[15001] Could not load navigation space for subject area Odwt.

Reply

Shiva Molabanti

October 12, 2016 at 12:06 am

Looks like you have a parent/pre seeding table to Dim – Organization physical table. How did you join dim org table to fact. Do you have any other table in between? If you have any, then you should bring that tabe to Dim-Org Logical table. (Just drag that table directly on existing LTS for Dim -org and make sure it will not create a new LTS for you).

Reply

Muzammil Husain

October 12, 2016 at 7:01 am

Hi Shiva,
I have to make the Region hierarchy Region->Country->Point of sale->agent details. Agent no is our granular level but sometimes we do not get the information of agent and only POS level information is available. When I make the drill down it doesnt show those records which are at POS level. Could you please suggest something on this so that i could get the data at a POS level whereas we do not have the key data available for some records.

Reply

Nicolas

October 20, 2016 at 10:39 pm

In 11.1.1.9, I’m trying to create a BIP report and data model from an OBIEE dashboard page. I go to Edit Dashboard>Print & Export Options>Create Layouts. Instead of a BIP report all that is displayed is a blank page with ‘Untitled’ in the upper left corner.

Do you have any troubleshooting advice? (Thanks in advance)

Reply

hadi

November 7, 2016 at 10:15 am

Hello Shiva,

I’m using bi publisher and I have a report layout that is already linked to a data model.
I’ m trying to add a web connection to call a soa service in the data model, problem is when I do this the layout breaks from the DM and I can only see the old data sources in the layout is there a way to join the layout to the modified data model ?
Thanks.

Reply

Kashef Siddiqui

November 21, 2016 at 9:51 pm

Hi,

Is there a way to pop a message while a dashboard query is fetching data?

Reply

Nilay

November 22, 2016 at 11:44 am

Hi Shiva ….can we define action links on derived columns (if we have column values based on case statement in BMM layer) ? The column values are different than the actual value in database.
e.g
CASE
WHEN “table”.”Id” = “table”.”NId”
and “table”.”Group Name” IS NULL
THEN ‘D.R.’
WHEN “DB”.”table”.”Id” = “DB”.”table”.”NCRId”
and “DB”.”table”.”Column” IS NOT NULL
THEN Replace( “DB”.”table”.”Column”, ‘BU_’ ,’ ‘)
ELSE ‘Junk’
END

Applying Action link on the output value of this case statement.

Regards,
Nilay

Reply

Katie Baker

December 14, 2016 at 2:05 pm

Hi Shiva,

We use OBI in Taleo for reporting. We have added an additional compound layout to our analysis, where we have a pivot table view on the first tab and the table view on the second tab. We would like to export the data to Excel where the pivot table view populates on the first tab and the table view populates on the second tab (as it does on OBI). However, when exported to Excel, only the pivot table view from the first layout exports. The table view from the second layout does not export. Is there a way to export this information to Excel where both tabs populate on the spreadsheet without creating a dashboard?

Thanks!

Reply

sathyanarayana

December 22, 2016 at 10:20 am

Hi all,
I need to take backup of catalog and bar file as daily wise could you please help me someone
how to achieve it and give step by step process

if any clarification please let me know

Regards
sathyanarayana ch

Reply

aditya

January 30, 2017 at 2:56 pm

Hi siva,

we are facing some performance issue with obiee application.When we trying to login it is taking longer than usual and sometimes it’s throwing an error like ‘Site can’t be reached’, but both Em& console and all other services in EM are up and running. we tried restarting the services couple of times and we bounced the db and server as well but noting is helping us. my support team sent an error message that i’m not able understand…could you please help me with a solution to clear this issue.
Please find the below error :
start with ACLE. and it’s length must be less than76 characeters. Also key must be defined in adf-settings.xml ORG.APACHE.MYFACES.TRINIDAD.UIXEDITABLEVALUE.VALIDATE_EMPTY_FIELDS does not satisfy one or more these criteria so returning null value>

Thanks in advance,
Aditya

Reply

Mark

February 9, 2017 at 6:30 am

Hi,

Sometimes i am getting the error “The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.”

my server is working on a F5 router.

Can u let me know if any of you have faced such problems

Thanks
Marc

Reply

Sonal

February 10, 2017 at 8:25 am

Hi,
Like we use hierarchy level for time based dinmension and this enable us to drill from Year to Quarter, then to Month and so on..
Could we go backwards,i mean, from Mnoth to Quarter and then to year.

Reply

Reeta Amin

February 10, 2017 at 7:40 pm

Hi Siva,

I have faced error while configuring OBIEE.
configuration failed at configure BI Domain step.

if we have to start configuration process again how can we do that with out using new domain.
that means how do we clean up files manually so that it create domain with same name (bifoundation_domain)

thanks,
Reeta

Reply

satish

February 10, 2017 at 7:53 pm

Hi Siva,

We are facing an excel 2007 download issue in OBIEE 11.1.1.9 after an inplace upgrade from OBIEE 11.1.1.7. When we try to export a large report with SSO link getting an Error: There was an error processing your download. Please check with administrator, but with default link could download the same size of report.

If you had seen this type of issue, please provide your valid inputs.

Note : With default analytics link, we are able to download more than 65K+ records to excel 2007 and CSV but with SSO link could download only for CSV .

Thanks in Advance!

Thanks.

Reply

Soumya Mitra

February 14, 2017 at 10:05 am

Hello Shiva,

Can we display 20 decimal places in a graph?

rgds,
Soumya M.

Reply

murali

March 8, 2017 at 7:38 am

Hi shiva,

In obiee 11.9 version i am facing the below issue.

Time_Dimention and Fact table joined based on Date column. In the report if i put filter only on time dimension( not on fact table) like time.date > ’01-Jan-2016′ then in the physical query i am seeing 2 conditions
One is based on Time.Date >’01-Jan-2016′
and extra condition fact.Date > ’01-Jan-2016′. The second condition should not come rt.
in 11.7.4 version it is not coming. Could you please help in this
Thanks

Reply

Jimmy

March 8, 2017 at 10:21 pm

Hi Siva,
I have a question about dashboard prompt, is there a way to have a date prompt sort desceding when it is constrained by two other prompts. For regular date prompt I was able to do that by changing it to SQL (from choice list) and added order by one desc to the SQL. When constrained the SQL option goes off. Any input is highly appreciated.

Thanks,
jimmy

Reply

Ragu

March 24, 2017 at 9:39 pm

Hi Siva,
I have been reading your blog for quiet some time. This is a great blog to read about various features and possibilities in BI.

I am having an issue with ragged hierarchy in OBIEE and, really appreciate your inputs. I am trying to build a report, similar to hierarchy (where I can expand and collapse the tree structure) except that the values of child should not roll up to the parent. The report should display individual values that each person has in the organization parent should have his values and child should have his. I tried with ragged hierarchy set up, where the child values roll up to their parent.

A——-
B——
C——
D——
E——

A is the Level1 guy in the organization, with B and E under him.
C and D are under B(Level2). E(Level2) has no one under him.
The report has like five measures in the pivot with current month, last month and their change percentage calculations.

Reply

Sahil

April 5, 2017 at 1:48 pm

Hi Shiva, i read your post on Waterfall chart. you ended that post with leaving comments saying you can envision this to be used to create Gantt Charts, just curious to know if you found a way to achieve this ?

-Thanks,
Sahil

Reply

E'm

May 5, 2017 at 10:28 am

Supplier Sales RPD ?

Hi Siva,

I am just going through the Oracle University OBI study material all the exercises are based on the Supplier Sales subject material.

Do you have the RPD file that it references to? I already have the database schema Supplier2 but I don’t have the RPD it is referring to.

Thanks in Advance.

Regards,
E’m

Reply

Felipe

May 5, 2017 at 5:07 pm

Hi Shiva,

I am very new to OBIEE and I need to create a pie chart on OBIEE analytics involving two measures. All examples I find on the internet consider measure and dimension but that’s not what I’m looking for.
Can you please help me with that?

Thanks a lot

Reply

SK

May 8, 2017 at 2:21 pm

Can graphs be created from reports which have unions. Is that possible?

Reply

Shashikant Singh

May 23, 2017 at 7:21 am

Hi Shiva,

I’ve one query need your answer, I’ve created one analytics in oibee but whenever I’m trying to go to the next page, it is not coming.. Means I’m unable to go to the next page of report..
Please advice..

Thanks and regards,
Shashikant singh

Reply

Raj

May 25, 2017 at 11:22 am

Hi

Want to show data(example :count of deals) for every 15 days ..like (0 -15) days ,(15 – 30)days,(30-45)days..
How to achieve this in obiee 11g.

Reply

Praveen Chandra

May 31, 2017 at 4:12 pm

Hi shiva,
I am facing a error while accessing the offline catalog throgth catalog manager.

Error:Error initializing/loading existing Catalog:

I have downloaded the catalog root file from production and i have created one folder in my local machine and trying to access the folder througth offline mode.

OBIEE version 11.1.1.7.15

Regards,Praveen Mallu

Reply

Kumaran

November 6, 2017 at 10:17 pm

Hi Shiva,

Nice to meet you.
I’m trying to extract the contents of the offline catalog(Archived) file.
I don’t have the BI Publisher installed in my local. I don’t want to install the same.
All I want is to Extract the Catalog(Archive) file contents into my local folder.

I am using windows 7.

Let me know is there any possibility.

Thanks
Kumaran

Reply

Deepak

November 14, 2017 at 7:08 am

Hi Shiva,

Is there any way in Obiee to export all the joins information used in rpd to a file ??

Thanks
Deepak

Reply

raj9blog

July 27, 2018 at 12:16 pm

Hi Shiva,

Recently I went to an interview they asked me a question an Obie agents.
Q. A dashboard has four pages p1,p2,p3,p4 .
How to create an agent that run p1 to particular user1/mail, p2 to user2/mail, p3 to user3/mail, p4 to user4/mail.

How to achieve this in Obiee??
Thanks
Rajesh

Reply

raj9blog

July 27, 2018 at 12:23 pm

Hi Shiva,

Recently I went to an Obie interview the question was like this.
Q. A dashboard with four pages p1,p2,p3,p4 are there ,how to schedule a page p1 to a particular user/mail , p2 to particular user/mail, p3 to particular user/mail ,p4 to particular user/mail .using Obiee analytics agents without using manual interaction for inserting users or mail I’d?

Thanks
Rajesh

Reply

raj9blog

September 10, 2018 at 7:55 am

Hi Shiva,

I had installed OBIEE 12c(12.2.1.3.0) on windows 10 , the installtion was successfully.

when i open the analytics i have not found the default subject area.

And i check the folder of where metadata of RPD in (\user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations) the “customizations” folder was empty .

1.) Can you tell me the process how i can get back the liverpd.rpd ,

2.) if there is no process to get back rpd , then i need to install the OBIEE again ? pls clarify me ?

Regards,

Rajesh

Reply

Prakash Kumar

January 22, 2020 at 11:51 am

I want to add a column in obiee12c, but dont want it to get exported in CSV extract. But it should be available is some view, so can not hide it.

Can you please suggest if its possible.

Reply

Shiva Molabanti

March 4, 2020 at 12:54 am

No it’s not possible. The export is what you see in the report will what you get. If you need a selective columns better to create another report.

Reply

Bubu M

March 3, 2020 at 1:40 am

Hi Shiva,
Need to display my dashboard date, based on the year selection at the prompt, to show the last five years. Eg. Prompt selection is set to 2019, expect to see data from 2015 to 2019.
How can I set the year filter to do it dynamically based on the prompt selection.
Version: OBIEE 12c
Do have a Year column

Thank you,
B

Reply

Shiva Molabanti

March 4, 2020 at 12:51 am

Babu,
You can use the presentation variables to achieve this. Set the presentation variable for the dashboard prompt year column. And in the report, in Filter section use the following condition:
year >=(presentation variable)-5 AND Yeat <=(Presentation variable)

Reply

Ramesh Desai

March 26, 2020 at 7:30 am

I am getting error when i am trying to update values in report.
Error: system is unable to read write back template. please contact your system administrator.
OBIEE 11g version: 11.1.1.7.150120
Report view is: Pivot View

Reply

Chase

May 3, 2020 at 8:31 pm

Hi Ramesh just check if you have the write back template available in the desired path.

Reply

Hadi

January 19, 2021 at 1:08 pm

Hello,
Im facing an issue with BIP, i have a webservice DM that returns data correctly.
the response is a list
when i export the xml and use it in excel template, when running the report data is not returned in the layout.
please advise.

Regards.
Hadi safa.

Reply

Mehar

November 19, 2022 at 3:17 am

Hi,

Can you please guide me
If there is any way to enable attachment note option while delivering HTML using Deliver Results Directly button in an alert

Thank you,
Mehar.

Reply

OBIEE by Shiva Molabanti

Ask Me

641 responses to “Ask Me”

Leave a reply to goutham Cancel reply

Search

Recent Posts

Blog Visitors

BI Updates

OBIEE@Twitter

Follow Blog via Email

Blogroll

Disclaimer

Tag Cloud

OBIEE by Shiva Molabanti

Ask Me

Share this:

641 responses to “Ask Me”

Leave a reply to goutham Cancel reply

Search

Recent Posts

Blog Visitors

BI Updates

OBIEE@Twitter

Follow Blog via Email

Blogroll

Disclaimer

Tag Cloud