Search results for query: *

Hi, Iam having this selection cretiria to my object..It is giving the error as a not a single group group function..The syntax is : decode(@Select(Score Card\Cfo Approval Ind),'Y',@Select(Score Card\sumofactuals),0) sumofactuals is a measure object. I know that I have to give...

Thanks Brain..works fine.

Hi, I need to Concatenate two fields and display the result. But in between two fields, I need to separate them with : Here is the example what Iam looking for: Syntax: Concatenation(Proj_title,tpr_num) But, I want divide the two atrributes with special character as ":", How Do I get ?

Hey, We have 3 licenses for BO and we created 5 user ids. 5 users can able to log on to Webi at the same time and view all the documents and do the various operations. I wondered, how these 3 licenses are restricted for the no.of users? Any ideas..

Hi, Iam using BO6.5 version. When I formated my report with Row By Row AutoFit feature. It is not working. All the rows are same size even I applied this feature. Any idea please.

Steve, Client doesnt satisfied using the Alerts. How I can place the bitmaps into Server?

Steve, 2. Iam not inserting pictures in my report. Based on the project status(Green, Yello and Red), the report should dynamically pickup the color of the bitmap. I can able to do using Thick Client. When Iam doing with WEBi the bitmaps are not displaying. When I saved into excel or pdf the...

Steve, 1. Iam using BO6.5 2. There is a feature in 6.5 Defining objects in BO. You have to define the .bmp objects while you design the universe. I have to question what my client is lookin from BO. 1. We have one column with size varchar2(4000). It is not always 4000 characters. Client...

Hi Steve, Thanks for your response. I can able to display Bmp Files in the Report. But, when Iam saving the Report to an Excel it is saving, not able to visible any contents in the excel. It is showing blank sheet. The other reports which doesn't have BMP files can able to save as excel and...

Hi, Here is the report want to display. Key Initiatives Description Status Release ====================================================== sears sears cahmp migration Green 2004 In place of Green, I need to display some symbol with Green color..How this will be possible...

Steve, It is having LOV, but when Iam clicking the Values button it is not responding..

Thanks Steve. Iam using BO 6.5 the Syntax is parsing correctly and when Iam running the report it is not showing the values when I clicked Values Tab. Here is the Syntax: PV_PROJECTS.ORG2 IN @Prompt('SELECT ORGZ','A','PV_PROJECTS\ORG2',MULTI,FREE)

Thanks. But, we dont have fact tables in our schema..How to resolve the loops in this case?

Hi, When I created a Universe, the loop was formed. To resolve the loop I used 2 contexts. When Iam running the report it is prompting which context to choose as a parameter..I can able to Understand which I need to choose...but, when the End user point of view, how this will works? Any guess?

Hi, I have defined fixed no.of LOV's in the Universe and I can able to Select all the LOV Values in Thick Client(6.5). But, When Iam using the Same Universe in Webi(6.5) only the first 10 values are displaying. Is there any limitation with WEBi(6.5) to show the fixed no.of values? Any one can...

Hi, I created a user with Designer Access and try to log on Webi. It is not showing Universe pane. Only the general supervisor can only view the universe pane. Is this correct? or do we have privilege to provide access to the users to access the existing universe also?

Hi, I need to display the CLOB attribute values in the report, getting the following error when Iam displaying: ORA-03106: fatal two-task communication protocol error :-3106 IS BO is having this feature to allow CLOB attributes also? Murali

Here is the syntax in the Where Clause: PV_PROJECTS.RELEASE IN @Prompt('SELECT RELEASE','A','Projlookups\Codevalue',[MULTI],FREE) Release Column is Number data type and Iam having relationship in the Universe with Lookupid(Number datatype) and in the Prompt values are only input Varchar...

Hi, I have created a document using Free hand SQL and exported the same to Repository. When the end user opens the report(Thru WEBi) he is not getting the refreshed data as of that day. The report is keeping the same data when I developed the report. How the end user can get the refreshed...

Here is the Syntax, @Prompt('Select Org','A','Projects\Org2',[MULTI],FREE) The query is parsing. It showing the Values tab also. When I click values tab, there is no response. Sometimes the error is showing like Missing right parenthesis.. Regarding the Datatype: I have 2 tables: 1...