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, Thank you for your responses. I've tried to use both properties (SendOnBehalfOf and MailLogon) but none works with the olMailItem. I don't know much about the mail properties from VBA (in fact I am not that savvy in Outlook at all). Do you have like an example in how to use these methods...

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...

Thank you for the explanation, I saw it but I never understood it until know...

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...

can this affect the performance of queries petitions, dts, or jobs?

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...

Let me explain this question better: I need to have this in a virtual cube so I can make an calculated member that have this structure: [Measures].[Money]/[Measures].[Sales] *100 in order to make a percentage value. Is there a way to say in MDX Structure that the Money mesures will make the...

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...