Search results for query: *

Hi, I'm having trouble in insert a decimal value from SQL 2005 to Oracle 10g. I'm using DS 7.5.1.A and ODBC as a connection. The mistake is: [DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-01722: invalid number the field property are the same: decimal with lengh 8 and scale 2. Using...

Hi, I have a problem in relating 2 tables in a combo box based on two different keys. This is what it works: Both tables are related by keys. When the Record Source on the form is the name of table (e.g. Table1). In the Control Source of the Combo a key1 of the main table, then I enter in...

Hi, I need to change the outlook session when sending an e-mail using VBA from Excel. The main point instead of sending the e-mail from the session "me@office.com" it send it from another account: "myoffice@office.com". The only thing rigth now is the created e-mail with a string with the...

Hi, maybe this is a dumm question buy I'm new in VBA and I don't know what is missing. I want to get data from an Access database but I can't use the Connection object and I don't know why. I tried: Dim Conn As ADOBD.Connection (the error here is: User-define type not defined) -------- Dim...

Hi, I'm having a problem to connect a repository (which location is in SQL) in my computer. I don't know what I'm doing wrong. In the server where I can use the repository I'm including evereyone on the "Database Roles" and also a user with the same name that I use in the computer I want to...

Hi, I have a real dumm question: I'm trying tu put a value ' inside a varchar, like this example: declare @hola varchar(15) set @hola= "'hola" so thay the value of @hola most be 'hola (with the apostrophe) the Query analizer returns me the next error: Invalid column name ''hola'. how I...

Hi! I have a portlet (.jsp) that calls a BI Bean generated from JDeveloper. When I run or debbug this portlet in my computer I have no problem in navigate thru the page items. But when I put it in the Portal, I can't navigate it. I have this .jsp as my portlet for the BI Bean, I don't know what...

Hi, I have a portlet (.jsp) that calls a BI Bean generated from JDeveloper. When I run or debbug this portlet in my computer I have no problem in navigate thru the page items. But when I put it in the Portal, I can't navigate it. I have this .jsp as my portlet for the BI Bean, I don't know...

Hi! Does anyone knows why a procedure cannot function properly in a Mapping package on Oracle Warehouse Builder??? The procedure is valid and it runs perfectly on Toad. I put it in a mapping package as a post-mapping activity and it seems that this instruction doesn't work. I have other...

Hi, I want to export metadata, in order to use Oracle BI Beans. Does anyone knows what should I do? I tried with the OWB transfer (bridge) but I get an error, it seems the OWB Transfer is doing nothing. What user and host I need to use in the transfer parameters? Do I need another user with...

Hi, I have a third-party application that connects to OLAP Services using a MDX query. I'm trying to use two funtions: member [Measures].[GpoPar] As '({[Group].[All Group].[Cons]})' set [Cias] as 'Generate({[Measures].[GpoPar]}, "Suma")' Where [Measures].[GpoPar] is the value of...

I have this query that is the result of a third-party software: SELECT DISTINCT D.SucursalTiendas FROM (((HPapiro A INNER JOIN DGrupo B ON A.CnCveGrupo = B.CnCveGrupo) INNER JOIN DPapiroNiveles C ON A.CnCveCompania = C.CnCveCompania AND A.Nivel1 = C.CnCveNivelCuentas1 AND A.Nivel2 =...

Hi again, In a MDX sentence I want to put this value: set [Signo] as '(IIF ([measures].[ColumnaNivel1].CurrentMember.Name IS '010.Ventas',-1,1))' I tried in the cube as a calculated member and I had no problem at all. But as a "Set" or as a "member" condition the MDX...

Hi, Does anyone nows what is the difference between these two rows? NON EMPTY CrossJoin ({[GpoParametro]}, {[NivelCuentas].[Nivel2].members}) on rows {NonEmptyCrossjoin({[GpoParametro]}, {[NivelCuentas].[Cve Nivel2].members})} On Rows In the first one, it shows me rows with ceros in the...

The RAM usage for the process sqlserv.exe in the task manager of windows takes around 1.5GB to 1.7GB when there's no jobs, queries or dts running. If i restart the SQL Server service, the memory consumes 60 MB of memory, but, when i run any query, dts, or job the memory starts to grow until...

Hi, I have a problem in using 2 measures with different levels, let me give you an example: I have a measure "Money" in the folowing Dimensions: Company, and Store. And another measure "sales" that is only in the level company. The next step is to make that the measure...

Hi, I have a problem in using 2 measures with different levels, let me give you an example: I have a measure "Money" in the folowing Dimensions: Company, and Store. And another measure "sales" that is only in the level company. The next step is to make that the measure...

I have this query: insert into Hours (CnCveFolio, DxDescHorasRegistradas) select cncvefolio, HorasRegistradas as DxDescHorasRegistradas from temp_hexpediente where CdFechaRecepcion between '01/01/01' and '31/01/01' or (cncvefolio in (select cncvefolio from FechaCargaExpedientes)) and the...

Hi, I recently installed Service Pack 3 on SQL Server 2k and I'm running jobs that execute DTS that connect to an Interbase DB via ODBC. When you run manually the DTS it works fine. The jobs are returning the following error: [ODBC Interbase 4.1 Driver] [Interbase] unavailable database The...

I have an third party aplication that runs in SQL 2000 a delete statment in a table and then an insert statement in the same table, the log file for the insert table is about 40 Mb every time it runs and in the same connection it runs about 40 times. Before it runs every time I run a SP with...