topic Re: Building a navigation table for cube data source in Developer

Building a navigation table for cube data source

rohong — Mon, 10 Apr 2023 23:58:06 GMT

I'm attempting to build a custom connector for a cube data source. I'd like to model the navigation behaviors like the Adobe Analytics Connector that is available. In the example video, it showed a navigator that allowed the users to select both measures and dimensions for the query before applying and generating data. Is there any documentation or references that show how that behavior is achievable? So far in the navigation table samples, only tables and functions are covered.

I've attached screenshots from the example below showing the dimension and measure selection workflow

Thanks!

Re: Building a navigation table for cube data source

Anonymous — Wed, 12 Apr 2023 02:54:18 GMT

Hi @rohong ,

If I understand correctly, you are trying to connect to Adobe Analytics. And you can't find Dimensions and Measures in the navigator. First, please make sure those info exist in Adobe Analytics source exactly. Then which version of Adobe Analytics API you selected in below screenshot? Please select the latest one: 2.0...

Adobe Analytics 2.0 APIs

If the above one still not working, you can consider to raise one ticket in Adobe Analytics community due to this connector refer a third-party service.

Adobe Analytics Dimensions and Measures missing in Power BI

In addition, you can refer the following links to create a custom connector...

Power BI Custom Connector: Connect to Any Data Sources. Hello World! - RADACAD

Custom Data Connector: How to Deploy and Test

video: Create custom connectors in Power Bi

Best Regards

Re: Building a navigation table for cube data source

rohong — Wed, 12 Apr 2023 15:52:48 GMT

Hi Rena,

I'm not looking to connect to Adobe Analytics. I want to develop a custom connector that presents a Navigator view that looks like the one in the screenshots. I was using it as a UI reference. I'm looking to understand the Power Query M definitions that would let me build the right table and types. Currently, the documentation does not have much information beyond simple tables and functions, no cubes, measures, or dimensions.

Thanks!

Re: Building a navigation table for cube data source

Matas_skYwolf — Fri, 29 Sep 2023 09:44:54 GMT

Have you found a solution or example how to create something like this?