By Shawn Lafferty-Oracle on Mar 01, 2013
Have you ever wanted to show actual values vs. remaining on the same line using different colors for each? This can be a very tricky exercise in OBI. First, you have to create 2 separate date sets, one set of dates that represent time before the data date for actual values, and another set of dates after the data date for whatever is remaining. After this, you want to make sure that you can clearly show the data date so it is known where the actual values end and where the remaining begin <see chart below>. After you have created the time separation, you can begin to assemble your graph. In OBI, the order in which you place your lines matters for the simple fact of which bar will overlay the other. Since our actual bar will stop at the data date, we want this bar to "appear" on top of our remaining, so we will see actual values up to the data date, then remaining after the data date. The last part of this involves the display of the data date. I accomplished this by placing a large number in a field that I used for the data date. This value represents the height of the bar essentially, so when you try this in your environment, you may need to adjust the value according to your projects values.
If you want to see the analysis (OBI 22.214.171.124.7), download the files here