Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 eac...
Need Help
  • jeffshieldsdev's avatar
    jeffshieldsdev
    7 years ago

    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
      }
    ],
...

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

    • jeffshieldsdev's avatar
      jeffshieldsdev
      Solution Sage
      7 years ago

      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
      }
    ],
...

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        In the following example you gave:

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

        what is the top 10000 based on? Is it the top 10000 based on evar123? Is it the top 10000 alphabetically? And what happens if I change evar123 to "null"?

         

        Thanks!