Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 703
  • Last Modified:

BW - How to create Date Key Figure

Hi gurus,

I had being facing BW2.0 Date Key Figure's issue for quite a while. Doesnt seem to have any idea
on how to start doing it.

What happen is I need to create infoobject of key figure type that can calculate the different between two dates & return the number of days. Is it possible to be done via extractor/admin workbench? Dont tell me to use excel formula.
 
It is use in to calculate delivery time for MM module.

Any guidance is highly appreciate.

Thank in advance.

hydra
0
hydra
Asked:
hydra
1 Solution
 
sharaddCommented:
Hi hydra,
I don't know about BW but if you can use ABAP in your BW module then it is very simple.

Data : date_diff_in_days(5) type N.

Data : date_1 like sy-datum.
data : date_2 like sy-datum.


date_diff_in_days =  date_1 - date_2 .

I think you can use formulaes in Date key figure.

I am sorry if this doesn't help you.

Sharad
0
 
hydraAuthor Commented:
Hi Sharad,

thanks. let me try to research on your idea. thanks.

hydra
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now