1

Topic: To get the total from the fact on the maximum date from the fact

All greetings!
I try to invent as to make the such:
Fakt1 :
The total Date
100 2/1/2017
200 4/3/2017
Fakt2 :
The total date
50 3/1/2017
150 5/1/2017
In OBIEE I want to reflect the total from Fakt2 where dates more than the last date in Fakte1 (sum (case when max (Fakt1. Date) <Fakt2. Date then Fakt2. The total end)). Such generally it is possible on mother Earth?)

2

Re: To get the total from the fact on the maximum date from the fact

Nenormalka, certainly it is possible.

3

Re: To get the total from the fact on the maximum date from the fact

Nenormalka;

1 with fakt1 as (
2 select 100 s, to_date (' 2/1/2017 ') d from dual union all
3 select 200, to_date (' 4/3/2017 ') from dual
4)
5, fakt2 as (
6 select 50 s, to_date (' 3/1/2017 ') d from dual union all
7 select 150, to_date (' 5/1/2017 ') from dual union all
8 select 25, to_date (' 6/1/2017 ') from dual
9)
10* select sum (s) ss from fakt2 where d> (select max (d) from fakt1)
SQL> /
SS
----------
175

.....
stax

4

Re: To get the total from the fact on the maximum date from the fact

Lary Denis;
And how it to make?) Share wisdom.

5

Re: To get the total from the fact on the maximum date from the fact

Stax, I need to make it through OBIEE Answers, instead of request.

6

Re: To get the total from the fact on the maximum date from the fact

You want to construct a show-window where it will be reflected only 2 "where dates more than the last date in Fakte1", or you already have a show-window where two facts are connected, and to you it is necessary to superimpose the filter on this show-window?

7

Re: To get the total from the fact on the maximum date from the fact

Be or not to be..., I have a show-window with two facts and on a straight line with the friend the friend are not connected, only through reference manuals. Also it is necessary to make on the basis of them the analysis.