Merge Dimension

[ktm]

I have three Tab in my Reports.First tab is from different universe, second one is from Different Univesre.In third Tab i have combined the Result.I am getting all the clients of the first tab as well as second tab and the amounts of that clients.

In both the tabs we have similar names clients, We want to have only one name in the Third Tabs. It is Showing on the report Twice, not Once.
For example
We have SAM in the First tab and amount is $80 and in the second tab we have sam and amount is $20.
Than it is showing both the SAM and sam $20 and $ 80

Thanks In Advance

Thanks
Pooja

[Dave Rathbun]

[jsanzone]

Pooja,

Have you tried to apply "trim()" to your data? I too have ran up against the "SAM" and "SAM" situation, however, in my grid if I change the entry for that row of data to have trim() applied, it "cleans up" the data and aligns better. So, if you have a column called [customer name] sitting on your grid, highlight that column, open the Fx, and change it to read =trim([customer name]).

Just a shot in the dark and sometimes it seems like a silly thing to need to apply, however, some systems generate trailing spaces unnecessarily and to the un-aided eye it can be undetectecable.

Thanks,
John

[ktm]

I have merged the Client Name of Both The Systems and In my first Tab i have Total client is 52 and the In Second tab i have 32 and in the third tab i have total 82.In that there are similar client Name but in one data provider we have Lower Case and in other we have Upper case.We want to Display only Distinct Client. Like in first Tab we have 'SAM' and in the Second TAB we have 'sam' so we want to display only one sam in third TAB.
Thanks
Pooja

[jsanzone]

Pooja,
there is function called upper() "Converts a string to upper case"...
Can you try that and let us know what happens?

Thanks,
John

[ktm]

Thanks for Your Reply.I tried to convert one objects into lower case in universe.but still nothing has changed.
still the same.
Thanks
Pooja

[mikca]

Pooja,
You need to convert your names in the universe or in the reports' sql. You cannot merge report variables which is a significant weakness of BO.

In your sql add trim and upper to name fields and then you can merge easily.

Note also that if the money values are dimensions then they will show on separate rows, for merging they need to be measures and you might need to create a variable = Sum( [Money Value] )

Mick

[ktm]

Thanks for Your Reply Mikca, you mean to say that because of Case Sensative it is showing in different Cell.One object Character is in Upper case like "NEW YORK" and Another one is "New York". i have measure for the Amount using SUM([Amount]).
So, You want me to change one of those objects in lower or Upper Case in Universe.?

IN Report it is showing as Below:

NEWYORK $2000
NewYork $1000.

I want NewYork $3000


Thank You.
Pooja

[mikca]

Siru
I suggest that you establish a standard way of formatting these objects and apply that standard at universe level.

I suggest that your standard be
Trim( Upper( FieldName ))

and then you can join in your reports and, also in the reports, format the fields whichever way you like. I use WordCap( Lower( [Object name] )) in my reports

Mick

[jsanzone]

Pooja,

[Dave Rathbun]

It won't help to do the conversion (upper, lower, initcap) in the report as the values have to be the same before they get linked (merged) as dimensions. They have to be the same coming from the database.

[ktm]

Hello Dave,

Thanks for Your Reply.You mean to say that i need to make any Upper or Lower Case of those objects in the Universe rather than in Report Level.


Thank You Again.

Pooja

[Dave Rathbun]

Yes, which is why I assume you started this topic in the Designer forum.

[pdub]

Sorry to hijack this thread but Mick could you elaborate on converting the names in the reports' sql?

I have two data providers, the key to link these two is capitalised in one provider, lower case in the other so merging this dimension fails.

Adding a dimension in the universe is unfortunately not an option at the moment....any help much appreciated

[Jansi]

Welcome to BB! I think Mick meant modifying the SQL generated by BO.