Adding to what asim cholas said... 1) If you are getting your time value from a date column from your database and you are wanting to convert it to your timezone to display on your report, then you can use the code below in your column formula: TIMESTAMPADD(SQL_TSI_MINUTE, 30, TIMESTAMPADD(SQL_TSI_HOUR, 6,…

I think there is a way to do this -- but to do it, you must: (1) Populate a presentation variable with your prompt (2) Use a Narrative view instead of the Filters view So, make your Location prompt into a variable prompt that populates a presentation variable named something like vLoc. Then in the Narrative section of the…

Yes, I believe you can do this by using a Narrative View. For instance, look at your Criteria for your report. Let's say you have your columns in the Criteria tab in this order: Name Address Phone Email So, in the Narrative section of your Narrative view you could put this in there: Name: @1 Address: @2 [br/] Phone: @3…

What Thomas Dodds said! In very simple terms, I think you could look at it like this... John is a member of the Sales group. You have given the Sales group permission to see the 'Commissions' subject area, but for whatever reason you don't want John to be able to see this subject area -- you DO however want all of the…

I know there is a way to add custom links to your dashboard -- in which you case you could make a custom link to go to whatever page you want. I've never tried it but I read about it here: How to Add Custom Links in OBIEE header / Presentation Services | The Big Data - Business Intelligence by… As for a link to close the…

On the surface this seems like it might be an issue of -- even though you are only seeing the date, the column is really a timestamp. So when you think you are comparing '09/09/016' to '09/09/016', you might actually be comparing '09/09/016 12:00:00' to something like '09/09/016 05:45:33:33'. I say this because this is…

Make sure that the column you are using for your filter is DATE or DATETIME character type. If so you should see the 'between' operator in the dropdown: EDIT: I just checked and even if the character type is CHAR or VARCHAR, it still seems you should be able to see the 'is between' operator. I am not sure as to why you are…

Thanks for the reply Gianni. Adding the quotes definitely gets the errors to go away, so that is good. BUT...the filters still are not working. Putting the quotes in causes the filter to return no rows -- regardless of case. Below you can see where I enter the state as 'OH' -- which I know should return rows (I've tested…

I think you probably have your User Input set to 'List Box' or something similar? Try setting it to 'Choice List' & see if that gives you the 'pencil' as well as the option to 'Enable user to Type Values'.

Additionally, you could also... (1) Click the 'dropdown' arrow of your prompt (2) Your list of values pops up. At the bottom of the list, you should see 'Search'. Click on that. (3) That brings up the 'Select Values' box. Look at the very top-right corner of this box and you should see a little pencil. Click on that…

Thank you Gianna. I am now just using the HOUR function as such: CAST(hour("CALL_CENTER"."CALL_START_DATETIME") as CHAR) In that same column formula I also use a case statement to change the hour into the format I wish. For example: CASE WHEN CAST(hour("CALL_CENTER"."CALL_START_DATETIME") as CHAR) = '0' then '12:00 AM'…

My apologies for butting into this topic without any suggestions to the OP -- but I didn't know how else to ask this question to Thomas Dodds... The link you provided for the Sample App seems like an amazing resource! My question is...is there somewhere that we can download the RPD being used there? There is so much I…

I'm wondering if using presentation variables for all of your prompts would help with this. For instance... On page ONE you have prompts: Region (set this to populate presentation variable vRegion1) Country (set this to populate presentation variable vCountry1) State (set this to populate presentation variable vState1)…

Yep...defining my columns on the 'Columns' tab seems to work. It seems weird to me that it would not auto-generate the columns based on my SELECT statement...but what do I know? At least we got this figured out now. Thanks for all of the help!

Thank you both for your replies. I removed the ';' from the end of my query. I also explicitly named the columns I am selecting (rather than use the '*'). The query is now like this: select account_num,fname,lname,address1,address2,city,state,zip from ARSchem.ACCOUNTS A where A.account_num in (select B.account_num from…

Wow...looks like I need to work on my internet searching skills. I googled but never found that documentation you've provided. Thank you VERY much. This was a great help.

If you are simply wanting to always return data that is within the past 3 weeks, then why can't you just add a filter to your report that is something like this: "Date"."Date" is greater than or equal to timestampadd(sql_tsi_day,-21,current_date) I use the '-21' because there are 21 days in a 3 week period. I am using…

That worked. I went with: Evaluate('TO_CHAR(%1 ,%2)' AS CHAR "Inv"."Date Entered",'MM/DD/YYYY') ||'-'|| Evaluate('TO_CHAR(%1 ,%2)' AS CHAR ,"Inv"."Date Sent",'MM/DD/YYYY') Thank you!

Christian Berg and Gianni Ceresa. Thank you both for your replies. Both of your replies give me some direction in which I can start looking, decide on my options and make a decision. That was exactly the sort of feedback I was hoping for. Unfortunately I think I can only mark one of the answers as 'Correct' -- so even…

I know this is an old post so you may have found your answer by now... But I just came across this post and thought I would share what I thought might be a helpful solution. Add a target="_blank" attribute to your links (anchor tags) You can see a more detailed explanation here: How to Make Links Open in a New Window or…