Skip to Content
Former Member
Aug 19, 2015 at 02:06 PM

Merging Date Dimensions from Excel Data Source - Not Possible?



I am have two dimensions of dates imported from excel. I want to merge these dates together to create a superset, but I sap webi is not allowing me to merge them (cannot click OK in merge dimensions dialogue box). The sets of data seem to meet the requirements for merging (both are same formats). Why might I not be able to merge them?

I tried using ForceMerge to no avail (I do not know how exactly it works).

Specifically this is what I'm doing:

I have the dates of when two pairs of shoes, A and B, have been sold. I want to graph the number sold per month. So if 1 pair of shoe A was sold 30/1/2015 and another 31/1/2015, I will graph "2" (y-axis) in my January 2015 bin (x-axis). Therefore, I must create my x-axis range from a merge of shoe A and shoe B's sale dates.

Thanks in advance for your help.

Using sap webi service pack 5 patch 5.