Recent content by mur76

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