Merge field between field data provider and fieldvariable

building reports webintelligence
1

Hi expert,

I’m having a problem to merge 3 dimensions. This is because the fields are not exactly come from data provider. I have 2 fields :

a) L01 Month Name (This is from data provider)

Jan, Feb , Mar, Apr, May Jun, July, Aug, Sept, Oct, Nov, Dec

b) Average Yearly (dimension variable created in webi)

c) Average 1st Half (dimension variable created in webi)

I want to merge this 3 dimensions into 1 variable which expected like :

Jan, Feb , Mar, Apr, May Jun, Average 1st Half,July, Aug, Sept, Oct, Nov, Dec, Average Yearly

Do you any have any ideas on how to merging those objects because this is my bottleneck to complete my reports.

Thanks & Regards,
-Syahida-

norsyahida.saadon (BOB member since 2011-07-11)

2

Welcome to B:bob:B!

It’s not possible to merge dimensions like this.

Check the user guide and learn what merging of dimensions is and how it works.

Also this blog post can help to understand it:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Dear Sir,

May I know which user guide that I can refer?

Thanks & Regards,
-Syahida-

norsyahida.saadon (BOB member since 2011-07-11)

4

[quote:9127eb2ed3=“norsyahida.saadon”]May I know which user guide that I can refer?
[/quote]
Sure. It’s “Building Reports with the SAP BusinessObjects Web Intelligence Java Report Panel” for the BO version that you use. Check the chapter called something like “Merging dimensions…”.

Any product guide can be downloaded from here:
http://help.sap.com/businessobject/product_guides/

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

Thank you sir,

But the problem is one of the dimension that I created is not from data provider.This is a variable that I created. (For eg : “Average Half”). But for monthly data , it comes from data provider. I cannot use ForceMerge() function because it is not a measure or number. Is they any way that I merge this 2 fields into one?

Thanks & Regards,
-SYahida-

norsyahida.saadon (BOB member since 2011-07-11)

6

That’s way I wrote you that what you want to achieve using merging of dimensions is not possible.

You probably need to use a custom SQL where you would use set operator UNION (select values UNION select other values). However, my guess is that you use an OLAP universe (is that correct?) where this is not possible to use.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

7

Yes sir, I’m using OLAP universe. Anyway, thanks again sir…I will try to design the report in other way.

Thanks & Regards,
-Syahida- :slight_smile:

norsyahida.saadon (BOB member since 2011-07-11)

8

You could also try adding the missing values into the dimension in the OLAP cube.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

9

Ok sir, I will try it later. Anyhow, in my mind right now, I’m creating a new table from other relational database and create 2 fields that can present the missing value. Then, I will merge using different 2 queries. This is only a theory, still not sure whether it is working or not. If not working, then I need to add a missing values into the OLAP cube.

Thanks & Regards,
-Syahida-

norsyahida.saadon (BOB member since 2011-07-11)