Looker Studio Connector only recognizes dimensions...

patrick127 · 03-02-2023 03:48 PM

Hi,

I made a custom Looker Studio Connector that pulls from some internal metrics. Even when I return the getSchema() data as follows (see below) looker seems to pull in everything as a dimension.

I’m wondering:

Is this a problem?
Is this connected to my other problem that when trying to view the data I get an meaningless error (see following screenshot) and my getData() method is never called? Does looker skip calling getData() if there are no metrics defined?

{ "schema": [ { "dataType": "STRING", "description": "A unique path to just one metric.", "id": "MetricKey", "name": "Metric Key", "semantics": { "conceptType": "DIMENSION", "defaultAggregationType": "NONE", "reaggregatable": false, "semanticType": "TEXT" } }, { "dataType": "STRING", "description": "Budget Plan, Forecast, Actual or Projected.", "id": "FiscalSet", "name": "Fiscal Set", "semantics": { "conceptType": "DIMENSION", "defaultAggregationType": "NONE", "reaggregatable": false, "semanticType": "TEXT" } }, { "dataType": "STRING", "description": "", "id": "MetricPeriod.Day", "name": "Period Day", "semantics": { "conceptType": "DIMENSION", "defaultAggregationType": "NONE", "group": "DATE_OR_TIME", "reaggregatable": false, "semanticType": "YEAR_MONTH_DAY" } }, { "dataType": "STRING", "description": "", "id": "MetricPeriod.Month", "name": "Period Month", "semantics": { "conceptType": "DIMENSION", "defaultAggregationType": "NONE", "group": "DATE_OR_TIME", "reaggregatable": false, "semanticType": "YEAR_MONTH" } }, { "dataType": "STRING", "description": "", "id": "Only.Year", "name": "Only Year", "semantics": { "conceptType": "DIMENSION", "defaultAggregationType": "NONE", "group": "DATE_OR_TIME", "reaggregatable": false, "semanticType": "YEAR" } }, { "dataType": "STRING", "description": "", "id": "Only.Month", "name": "Only Monthly", "semantics": { "conceptType": "DIMENSION", "defaultAggregationType": "NONE", "group": "DATE_OR_TIME", "reaggregatable": false, "semanticType": "MONTH" } }, { "dataType": "NUMBER", "description": "", "id": "Value_Integer", "name": "Value (Number)", "semantics": { "conceptType": "METRIC", "group": "NUMERIC", "semanticType": "NUMBER" } }, { "dataType": "NUMBER", "description": "", "id": "Value_Integer", "name": "Value (Integer)", "semantics": { "conceptType": "METRIC", "group": "NUMERIC", "semanticType": "NUMBER" } } ] }

patrick127

If I goto Explore from the configuration previously listed instead of Create Report I get this:

Anybody know what Error ID: 5aa4d76d is? Google itself gives little information.

Again, my getData() App Script code is never called.

chrisd1

I’m having pretty much the same problem. getData() is never executed. Everything comes in as dimensions. I’m try to log the schema result and I’m just getting

com.google.apps.maestro.server.beans.datastudio.impl.FieldsDataImpl$FieldsImpl@1827b010

which is no help.

isAuthValid() is the last thing to run after adding a chart. I was thinking that had something to do with getData() not executing. But, now you got me thinking it’s something to do with my schema. How can I get my schema return in the logger?

chrisd1

OMG, drive me out of my mind. It’s something to do with either the uppercase characters or underscores in the id. I removed all the non alphanumeric and set to lowercase.

.replace(/\W/g, '').toLowerCase().trim()

getData() is firing now. Spent two days trying to figure out why no getData() when the schema seemed to be working fine. Still shows as all dimensions but I think that’s ok. The metrics are available as metrics or dimensions once you add a chart.

vicampuzano

I made a simple test, and the metric is considered a dimension even in this simple case.

I don't know how to get dimensions and metrics separated.

I also tested just lower case characters.

Any idea?

Looker Studio Connector only recognizes dimensions?