Answer / latha

yes,we can add ALL in lovs of any obj.In unv level double click on any obj,in properties tab,edit the view sql tab&add below select statement
select distinct
Agg-yr-qt-rn-st-ln-ca-sr.state
from
Agg-yr-qt-rn-st-ln-ca-sr
UNION
select distinct
'ALL'
from
Agg-yr-qt-rn-st-ln-ca-sr
and enable the option"do not generate sql before running"

and develop a prompt for this obj

select where clause of this obj add
state=@prompt()
or
'ALL'=@prompt

Answer / prathmesh

@Prompt('PROMPT TEXT','A',<PATH FOR
LOV>,Multi,Free,Persistent,{'ALL'})

THIS WILL ADD AN EXTRA VALUE CALLED AS "ALL" IN YOUR LOV

Answer / bhaskar

Hi Thotadwh,

Thanks for the kind information


It's not a prompt message, it should be get as a prompt
value along with the List of values while refreshing the report.

Scenario:

Mono - We can provide Single value

Multi - We can select all possible LOV's one by one

ALL - Here, it will take all possible LOV's & need
not provide one by one

Note: Hope it's not a parameter of the prompt,

How will we get the "ALL" word along with the LOV's.


Is there any workaround at DB level or Universe or Reporting
level to get the word "ALL" into the picture at report level.
------------------------

Any answer will be helpful.

Thanks in advance.

Answer / bhaskar

HI LATHA,
UR STATEMENT IS FINE.
BUT
WITHOUT PROMPT IN WHERE CLAUSE:

WHEN I RUN THE REPORT USING PROMPT VALUE 'ALL' IT'S SHOWS A MESSAGE CALLED 'NO DATA TO FETCH'

WITH PROMPT IN WHERE CLAUSE:
IT'S ASKING FOR TWO PROMPTS,I.E
ONE PROMPT WITH LOV EXCLUDING 'ALL'
AND
SECOND PROMPT WITH LOV'S INCLUDING 'ALL'

I HOPE THAT HERE I AM GETTING THE RESULT BASED ON FIRST PROMPT//

LET ME THE KNOW REASON THAT, WHERE I AM GOING WRONG

Answer / satya

As per my knowledge, "All" option is not in Prompt. But by
using "list of values" option ,We can select All values.

Answer / thotadwh

I dont think you can do so as far as i know. We can do so by checking optional prompt in prompt parameters.

Answer / thotadwh

could you elaborate your question. what exactly you need. do
you want to get the prompt message as ALL or what is it
exactly..

How to make alternative rows red and green in WebI Report?

3 Answers   Accenture, Mphasis,

hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??

0 Answers  

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  

What is the report extension in webi and deski

2 Answers  

what is the difference between bo and cognos?

1 Answers  

limitaions of cross tab ?

1 Answers  

From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?

1 Answers  

Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90

1 Answers   CSC,

What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

3 Answers   iFlex, Maintec, TCS,

how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,

Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,

Explain when to use local filter and when to use global filter?

0 Answers