Pattern Matching functions in DP Macro

[Former Member]

Folks,

Can anyone tell me if there are any pattern matching functions in DP Macros? Here is the requirement:

If the time bucket is a quarter, then hide some rows. If the time bucket is a month or something finer, then show the same row. Assume that all the time buckets in the data view will be the same (no telescoping buckets profile)

So, suppose that I use BUCKET_DESCRIPTION and get the name of the bucket. If it is Q.* (using pattern matching lingo here), then I would like to set the row attributes accordingly. If it is M.* then set the row attributes to visible.

Can you please throw some light on this? Would you do it some other way?

Thanks,

Satish

[m_manimaran]

Hi,

You may try with the macro function BUCKET_DAYS(). This will find number of days in a given bucket.

Then you can write condition, If bucket days is more than 1 and less than 7, then it is weekly.

If bucket days is more than 7, then it is monthly.

Please see if it is helpful for you.

Regards,

Manimaran M.