Search results for query: *

Hi Dave, my company is in the process of upgrading to Oracle 12C and we are testing now. The environment is 12 CPU AIX Unix OS running 4 virtual Oracle Servers. We have installed 12C on one of the virtual servers. Each instance has 250 gigs of memory shared 70 for the OS and 180 for Oracle. The...

Oracle version 11G. How can I get the sessiontimezone variable to default or be the same as the bdtimezone. I need this at the database level not the client level. Right now our bdtimezone shows 'America/Chicago', but our sessiontimezone shows '-5'. Thank you, Jerry

I am trying to make a materialized view fast refreshable. It works for inserts on the base table but not for deletes and updates. Here is the code to create the MV Log. CREATE MATERIALIZED VIEW LOG ON commerfj.tdl_test WITH ROWID, PRIMARY KEY, SEQUENCE...

Does anyone know if there is an option to audit when PDF's or Excel are opened in BOE. If so, where is the event set. Thank you.

Oracle 11.2 G I am joining a table where I only need two fields the join key and one other field. If I created a concatenated index that contained the two fields would oracle determine that it can get all the needed information from the index and avoid a full table scan. The table has 71...

Right now, I can see scheduled jobs that are running by looking directly at the CMS with an SQL query, but I am not sure how the ondemand is denoted in the CMS if at all. That is my question. How do I see the ondemand. I am looking for the Webi's that refresh on open. This will give me the...

Does Tek-Tips have a forum for Business Objects Web Intelligence?

We have noticed that if we cancel a long running report in either Infoview or on the CMC that the query will continue to run on the database server. Our Admin person talked to Business Objects support and they told him that this was by design. Hmmm. So, now if we cancel a report we need to call...

Right now I am using a hardcoded literal for the time zone difference. The number 21600 as 6 hours. Since I am in Central Time it will be either 5 or 6 hours. I would like to replace the 21600 with a function that returns the offset as a number. where 1=1 and alog.access_instant >=...

I want to add a link to an email so the user can click on and end up in a sub folder on infoview. I tried this where clarity is our web address to infoview. http://clarity\Public+Folders\Financial+Reports The sub folder is "Financial Reports". Does anybody know a syntax that will work...

Oracle 11G. I am trying to run this query against the dictionary which has a column of long data type. I want to pull the data out so I can use it. I get an error of illegal use of long data type. Is there a function to pull off the 1st say 100 characters. Toad will interpret the column and...

Oracle 11G 2. Will Oracle do "partition wise" pruning from a table partition to an index partition? Scenario. Table A Partition Range a_date Subpartition Hash (a_id) -- primary key Table B Partition Hash (a_id) -- primary key same as table A. Table C Partition Range c_date Subpartition Hash...

There is a column in all_indexes called join_index. I have looked up the meaning of this but I still don't understand what it means. I noticed that all our indexes say NO in this column. Can somebody explain the implications of this column. Thank you. select ind.table_name...

XI R3.1 Can anybody tell me where to find data on how long a Webi document takes to render. From the point in time that you click on the View document to the time the report appears. I can get data on scheduled Webi and Crystal instances from the CMS and I would like something similar for...

Is there an easy way with SQL code to convert a large comma delimited list into a temp table. I would put the code in a With Clause and use it in a subsequent join. The reason is, I am modifying some SQL that has several large in lists and I want to make these tables instead (temporary for...

Is there a variable or property in either the Universe or a Webi document that can be used to find or give the name of the BOE server? Thank you.

I have a button in a popup form that creates a where clause to be used when opening a report. It does not apply the where clause. How do I get this to happen. Code under button. Dim whereclause As String, args As String Dim DocName As String ''whereclause = "rqStatus = 1"...

When Crystal generates the SQL is there a way to include the currentceusername as a comment in the select list generated for the SQL. For example. select /* the user name */ field1, field2 from thetable Thank you.

I am looking for an easy way to add a period after each character in a field with some exceptions in an SQL Query. Examples of the data. MD = M.D. DDS = D.D.S. MD, PhD = M.D., Ph.D. CN, CRN = C.N., C.R.N. SQL Server 2000. Also, what is the way to detect only the lower case characters and...

I have a 1 byte text field that I want to force to upper case when the user enters data. Is there an easy way to do this? Thank you.