Search results for query: *

Hello, I am new to SSAS and need help. I have a Date hirearcy as Year->Quarter-Month and have calcualtions Current YTD,Previos YTD, Current QTD,Previous QTD based on shell dimension, which work fine. However my requirement is, if i have no facts(nulls) for atleast one month in a quarter for...

Well, I am running into same issue when running a report off of sql server database and with a stored procedure. We used run this report with out any issue earlier, we are running into this issue over the past few days.When SP is executed from query analyzer or from crystal, it works fine. Any...

Hi All, We are using informatica 7.1 and are having a problem with the Timestamp data type in a mapping. This shows as a long raw data type in the Target Qualifier and does not allow to link the port (Soure data type is Date in oracle). I read in some forums that Informatica 8 supports this...

I am trying to install the siebel Analytics 7.7 on windows and receivig the error "Language pack was called with incorrect parameters" "Language pack must be called via the base installer and cannot be executed directly ". I get this error when i run the setup.exe file. Can anyone point me in...

Hi , Is it possible to change the connection of the report pointing to the stored procedure.We have a single repository for dev and production.But when i create a report using the dev connection, it does nt let me point the report to prod connection. Thanks Naga

SantaMufasa, I create a package just as you suggested, but it runs for ever. Here is the code. ************************************************ Create or replace package WDWE_Rule as Function getWdWe( from_dt Date, closedate DATE, total_daysNUMBER, WD_WE Varchar2) return...

I want to use this procedure/function in informatica mapping, where i will be passing the From_Dte,To_dte and this proc/func will return the total weekdays and weekends.Ofcourse there is some more logic i ll be putting in this fuction to calculate the wd's and we's.

Hi All, This might be a silly question but..., I am trying to write a function in oracle that returns multiple values.I looked at some of the forums and online docs and found out that functions in oracle returns single value. Is there a way we can write this to return multipl values.If yes,can...

Yes.I tried it after creating the tab.I already have another alert to display different background color on the alternate row.When i apply the template the alert(alternate rows) works but not the new one and to mention this alert compares the variables.

Hello Everyone, Is there a way that an alert can be applied to a new tab created with a template.It is like this, i have a report with a tab say Tab A which also has a template Tmplt A. I am creating a new tab B with Tmplt A.My old Tab- Tab A has an alert and i want to apply the same alert to...

Hi All, We have an BCA issue with some of our reports that are scheduled (With Macros).BCA is running some of our reports multiple times, the scheduled action is "Custom Macros".Our macros typically refresh the report,save them to excel and email them to the users.Due to this problem, the...

All, Does the results(N.o of Values) in LOV has anything to do with the Results size that we set up in the universe's Control Tab ? The reason is that the LOV in full client is displying partial values/results.Ofcourse it works fine in Webi .Any idea ? BO Version -6.5 Thanks Naga

Is it possible to migrate the weni reports accorss the different document domains(From Dev to Prod).We have the same security domain for both dev and prod. Thanks Naga

Can we migrate the webi documents from development env to production env.We have both the domains in a single repository.

Hi , I have 3 table joined as A left outer join B left outer join C.But when i create the report with the objects from these 3 table ,it constructs the SLQ as C right outer join b right outer join A.Ofcourse both mean the same,but when i run this queries the left outer join query works more...

Thanks Steve for the useful info

Hi All, I think this is a silly questions but still would be helpfull to me. Can we include the objects(measures) from 2 different dataproviders in one table based on the common dimensions in webi 6.5 as we do in full client. I mean , is linking of dimension objects possible in Webi 6.5 which...

Steve, You mean to say that i need one connection for every user ? If yes ,can't one connection be shared by all users with their login parameters ? Thanks Naga

Hi all, We have several users in the database and would like to use their login info when connecting to the database thru BO (Universe connection).Is is possible to use their userid and pwd dynamically for universe connection on BO server instead of using 1 generic userid for universe...

It is as Decimal(8,2) in source(Informix) , Dev and prod. WE also tried to replace the DTS package with its copy thinking that the pacakage may be corrupt on server.But no use.