cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
WestJa Frequent Visitor
Frequent Visitor

Adobe Analytics Connector Limiting Dimensions

I am using the Adobe Analytics connector for one of my reports. One of my 'Dimensions' is called 'Websites' and the data is a URL, we look at over 100 websites and I am looking at the traffic for each one. When I use the Websites dimension it only displays 10 of the sites. Is there a way I can add a line of code in the advanced query editor to remove this limit?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Adobe Analytics Connector Limiting Dimensions

You'll want to use the Top parameter with your dimensions.  You can get up to 50,000 dimension values per call.

{Cube.ApplyParameter, "Top", {10000, "evar123"}},
{Cube.ApplyParameter, "Top", {1000, "evar234"}},

If you open the log for the Report Builder, you should see which elements are using "top" in the json of the reportDefinition:

... ,
    "elements": [
      {
        "id": "evar123",
        "top": 10000,
        "startingWith": 1
      }
    ],
...

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Adobe Analytics Connector Limiting Dimensions

Hi @WestJa ,

The Adobe connector in Power BI Desktop relies on the Adobe Analytics Report API to return tables.  
The above issues may be caused by that there are limitations in Adobe Analytics Report API and data may also be sampled in the API, please consult Adobe Analytics support.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WestJa Frequent Visitor
Frequent Visitor

Re: Adobe Analytics Connector Limiting Dimensions

Thanks for the response.

 

This isn't an Adobe issue, this is Power BI. Adobe report builder allows me to pull in data in the correct way which also references the API, I am looking for a specific piece of DAX which highlights the option.

Re: Adobe Analytics Connector Limiting Dimensions

You'll want to use the Top parameter with your dimensions.  You can get up to 50,000 dimension values per call.

{Cube.ApplyParameter, "Top", {10000, "evar123"}},
{Cube.ApplyParameter, "Top", {1000, "evar234"}},

If you open the log for the Report Builder, you should see which elements are using "top" in the json of the reportDefinition:

... ,
    "elements": [
      {
        "id": "evar123",
        "top": 10000,
        "startingWith": 1
      }
    ],
...