dynamic report dimension

[alexpanjhc]

Hi

I am creating a dynamic report.

Everything looks fine except that when I have 2 similar columns , they show together even i only choose the longer name one.

For example, in my inline load

dimension:

LOAD *

INLINE

[

    _dimension,                        dimension_type

    Customer,                        Customer

    CustomerID,                        Customer

   ......

]

in the list box, i will have the filed _dimensions to choose.

Everytime, I choose CustomerID, Customer also shows.

here is my condition in dimension tab for the straight table

= SubStringCount (Concat (_dimension, '|'), 'CustomerID')

but when i only choose Cutomer, it is OK.

How do I correct this problem?

[Anonymous]

Use this condition for Customer dimension (I prefer index to substring, that is not important):

=index(Concat (_dimension, '|'), 'Customer')>0 AND index(Concat (_dimension, '|'), 'CustomerID')=0

Regards,

Michael

[alexpanjhc]

Michael

when I first chooe CustomerID, it only showed CustomerID---this is good, but when I also choose Customer, Customer does not show any more... looks like it is a conflicts.

[Anonymous]

I see - the new problem apparently happens when you select both, and I think it works if you select any one of them.

The most relaible way is to change the value 'Customer' so it is not a substring of 'CustomerID' or any other value, for example use 'Customer ' or 'Customer|'.

Regards,

Michael

[#5]

can somebody kindly explain the exact purpose of the concatenation of the pipe symbol when using substringcount(). I successfully made a dynamic straight table using substringcount(concat(dim_id,'|'),'A')  but I don't understand the purpose of the '|'. I know that it works without it partially but not always. The help text for the function does not indicate why I need to combine a value with the pipe. Is it because substringcount needs more than one character to work ?

thank you

DH

[alexpanjhc]

My understanding is to isolate the words.

eg:if you choose 3 dimensions : customer, order, order date they will become with the pipe line :customr|order|order date.

hyperthetically, if you have a dimension called ror and you do not have the pipe line to separate them,

you will get

customrorderorder date

and the dimension ror will show even if you did not select.

just my 2 cents.

[#7]

alex - thanks that makes sense - appreciate your reply