Default values in IDT Prompt

[former_member640919]

I have to display in the prompt for eg: 201401, 201402,201403...201412 so that user can select one of them

@prompt('Enter the From  Fiscal Year and Fiscal Month:',A','',Mono,,non_persistent,year(getdate())*100 +FISC_PER.FISC_PERIOD)

Have to include year(getdate()) *100 +FISC_PERIOD.FISC_PERIOD in the prompt in IDT

[former_member4998]

Hi

Solution 1:

Use the predefined function TO_CHAR,

To_Char (Object from Data Base,'Required Format')

Solution 2

Other method is Use the custom display format option.

Find the below link for more info.

http://scn.sap.com/community/semantic-layer/blog/2014/04/18/bi41-business-layer-enhancements--create...

[former_member640919]

Hi,

I do not have display format issue. I have to include year(getdate()) *100 +FISC_PERIOD.FISC_PERIOD in the prompt in IDT i.e year(current_Year) *100+Database field in the prompt i.e. 2014*100+ 01(fiscal period) Lov should come as 201401, 201402 when a promtp is displayed

[former_member4998]

Hi

The you need to create LOV’s based on custom SQL and

select the “LOV’s based on custom SQL” object’s in the  dimension associate list of values.