cancel
Showing results for 
Search instead for 
Did you mean: 

How to creae days count variable in SAP BI-BEx

Former Member
0 Kudos

Hi Expert,

Required of varibale for days count (how many days report) in SAP Bex querry. i have querry restrcit on 0calyer/month & 0calmonth (cal.year/month) & 0calday (calender day). Querry starting date based on 0calmnonth variable. Advise me customer exit program for count of days in current month.

Regards,

Mohit

Accepted Solutions (0)

Answers (1)

Answers (1)

anshu_lilhori
Active Contributor
0 Kudos

Hi,

Just give a try to this solution

You can use replacement path.For example1. creat a new formula variable

2. Tab General: Global Settings ->Processing by: choose "Replacementpath"

3. Field Reference Characteristic will appear, choose 0CALMONTh

4. Tab Replacement Path ReplacementRule -> Replace Variable

with InfoObject; Replace with Attrib. Value-> Field Attribute apears, choose "0NUMDAY Number of Days"

Hope it helps,

Regards,

AL

Former Member
0 Kudos

Hi,

all steps are ok, but 0numday option are not in info-object. Pls. suggest me for 0numday option.

anshu_lilhori
Active Contributor
0 Kudos

Hi,

I want to bring into your notic that 0numday and 0numwday are the attributes of 0calmonth so there might be a chance that these attributes are noit maintained in 0calmonth.

If possible make a new calmonth using refernce as 0calmonth and in that new calmonth maintain attributes 0numday and 0numwday.

You have to select the check box with master data in infoobject to add attributes.

Once done with all the steps then use this new calmonth in you bex query designer and that attribute value will be avaialable.

Hope it helps.

Regards,

AL

Edited by: AL1112 on May 25, 2011 1:22 PM