Adobe Analytics Connector - Filter dimension by specific values

[Anonymous]

Hi, 
I'm using adobe analytics 2.0 connector and trying to filter on a dimension in the 'added items' step. 
The Dimension column is "variables/evar31.1" which is "Marketing Channel 1D MR" &
"variables/campaign" which is "Tracking Code [campaign]"

I want to limit the "Marketing Channel 1D MR" to include only values "SocialMedia" & "SocialmediaOwned". Otherwise, too much data is included and affects loads time. 

This is current code snippet:

= Cube.Transform(vrs...,
        {
            {Cube.ApplyParameter, "DateRange", {#date(2022, 10, 25), #date(2022, 10, 25)}},
            {Cube.AddAndExpandDimensionColumn, "DateGranularity", {"variables/daterangeday"}, {"Date Granularity.Level 3: Day"}},
            {Cube.AddAndExpandDimensionColumn, "variables/evar31.1", {"variables/evar31.1"}, {"Marketing Channel 1D MR"}},
            {Cube.AddAndExpandDimensionColumn, "variables/campaign", {"variables/campaign"}, {"Tracking Code [campaign]"}},
            {Cube.AddMeasureColumn, "Orders [purchase]", "metrics/orders"},
            {Cube.AddMeasureColumn, "Revenue [purchase]", "metrics/revenue"},
            {Cube.AddMeasureColumn, "Units [purchase]", "metrics/units"},
            {Cube.AddMeasureColumn, "Visits", "metrics/visits"},
            {Cube.ApplyParameter, "Segment", {{}}}
        })

I'd guess I need to add another applyParameter such as below but am not able to get to work:
{Cube.ApplyParameter, "Marketing Channel 1D MR", {{}}},

I've checked below and can't figure out still/not relevant, in case somehow can help:
https://community.powerbi.com/t5/Desktop/Adobe-Analytics-Connector-Dimension-Filters/m-p/1226737#M54...
https://community.powerbi.com/t5/Desktop/Adobe-Analytics-Connector-Limiting-Dimensions/m-p/676602#M3...
https://community.powerbi.com/t5/Desktop/Adobe-Analytics-Connector-Dimension-Filters/m-p/1226737#M54...

Thanks

[gmadraj]

I thought of this approach but If I need segments as filters then I need x number tables for x number of filters in powerbi dashboard. 

[gmadraj]

@Anonymous Just wanted to check if you had any solution for your problem. I am stuck as well. 

[Anonymous]

No, didn't get code to work. In case it helps as alternative, can try creating a segment within adobe and then adding this segment when adding items in pbi

[v-stephen-msft]

Hi @Anonymous ,

Cube.ApplyParameter(cube as table, parameter as any, optional arguments as nullable list) as table

 {Cube.ApplyParameter, "Marketing Channel 1D MR"},

It's said that it's optional, please try the above.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Stephen,
Thanks for above. I've played around with more but still not working, and not sure on code you're suggesting, if can add example maybe. 
Chris