Underlying SQL?

William.E.2474

Once I create and analysis in the analytics builder using the GUI is there a way to get to the underlying SQL to make modifications?

Chris.S.534

Hi William,

Unfortunately not. You can use a custom SQL query to get the information you require using the custom-made reports as data source.

See Manipulate fields in your custom datasets using SQL, https://community.d2l.com/brightspace/kb/articles/25603-creating-reports-using-analytics-builder#Manipulate

Hope that helps!

Anuja.k.619

Hello,

I am trying to build custom sql . I am trying to encode string into base 64 format. But i can not. I can easily do in MYSQL , oracle as well SQL. But that format does not work under analytics builder tool. Could anyone please help here?

or do i need to open a support case?

Thanks

Anuja

Krizzy.S.9720

Hello @Anuja.k.619,

Thanks for your question. I think you have created a post regarding this. Please do let us know if you need our support further!

Krizzy