Group Cloumns of few project components together in to a section

Questions & Answers
1

Hi

I have a report where I am creating a report which shows issues per each component on quarterly basis. I am able to do that but I wanted to group few components in to track so that we can show grouped view of components. i am using Aggregate function but I am not able to get desired result. I have created in measures and also in project on the columns. The code executes without error but doesnt show the group

here is the function
Aggregate({

[Project].[Component].[‘Component1’],

[Project].[Component].[‘Component2’],

[Project].[Component].[‘Component3’']

})

Thank you for your help

2

Hi @Santosh_Chamarthy

Welcome to the eazyBI Community!
If you are defining the calculated member in the Project dimension, the syntax should be the following. I suggest using the autofill when starting to type the project name and the component name

Aggregate({
[Project].[PROJECT NAME].[COMOPONENT NAME1],
[Project].[PROJECT NAME].[COMOPONENT NAME2],
[Project].[PROJECT NAME].[COMOPONENT NAME3]
})

Alternatively, I suggest importing Component as a dimension (described in the community post here Dimension Component as filter - #4 by zane.baranovska) which will allow you to create calculated members straight into the Component dimension!

Best wishes,

Elita from support@eazybi.com