Is that possible to Include Cyclic Group Name in List of Dimensions table in Adhoc reporting?

[#1]

Hi Guys,

I am working on Adhoc reporting and have list of dimension which I have included in a INLINE Load table called Dimensions.

Dimensions:

LOAD

*

INLINE [

Dimension

Year

Quarter

Month

Week

Date

];

What I am trying to do is? Create a cyclic Group 'Date Hierarchy' and Include above 5 columns in that group and then include Cyclic group in my dimension table.

Dimensions:

LOAD

*

INLINE [

Dimension

'Date Hierarchy'

];

and use this in chart or table.

This is the condition expression I am using

=SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Date Hierarchy|')

but it is not working.

Could you please suggest is this possible or not? If possible what expression I have to write. Kindly modify the above one.

[Gysbert_Wassenaar]

Maybe. It could have been fixed in SR10.

[#3]

Hi Gysbert,

Could you please guide me SR10 or SR11 I Should install to client and server both or only to client?

From where I can download SR11 and what is the steps to install it on Server as well as client?

Please share the path and supportive documents for step by step installation.

Thanks in Advance.