community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

HANA/In-DB Connection Fails to Extract Field Descriptions

Meteor

I've been using the In-DB connection tools to extract data from an SAP HANA environment; however, it fails to extract the Description from the View (see below). I've confirmed independently that the descriptions are maintained in the View (when connecting view Tableau or DVW the descriptions are accessible).

 

Is there a method or setting that I'm not taking advantage of that will extract the Description? Could there be an error in my ODBC Driver config?

clipboard_image_0.png

Highlighted
Alteryx
Alteryx

@matts1 This information is usually grabbed from the database itself. Now are these descriptions queryable from SAP Hana? Can see if you are able to query the description in SAP Hana?

Digan
Alteryx
Meteor

@DiganP Not sure if this is what you were getting at or not, but it looks like I can query the _SYS_BI Dimensions table and find Descriptions or other necessary schema data. Then I can simply "join" them together via a Dynamic Rename. I guess I was expecting the Description values to come through without any explicit query... which would be nice! Here's how it looks for me now:

 

clipboard_image_0.png

 

My second query then looks something like:

 

Select _SYS_BI.BIMC_DIMENSIONS.DIMENSION_NAME,
_SYS_BI.BIMC_DIMENSIONS.DIMENSION_DESCRIPTION

From _SYS_BI.BIMC_DIMENSIONS

 

Thanks for making me consider this option, it was a huge help!

@matts1 

Meteor

I've submitted a request for an integrated solution to the Designer Ideas page. Feel free to comment or star if you've experienced similar challenges.

 

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/SAP-HANA-In-DB-Connection-Field-Descriptions...

Labels