How to display the SQL query results (data source) as is on EazyBi?

[Aya AlJboor]

Hi,

I recently started working with EazyBi and have a request to generate a report that retrieves a couple of information from the “Zephyre Squad” plugin; I found that some of the fields could not be retrieved as a custom field into EazyBi so I create SQL query that retrieved all the needed data and made it as the source of the data on EzayBi; here I started strugling as I cannot make all the valuses as column!

so what is the best way to display the query result as is on EazyBi?

thanks in advance

[Sir Mārtiņš Vanags]

Hi @Aya AlJboor 

You can import additional data to eazyBI “Issues” cube (pulled from Jira projects) but there are certain limitations to that. eazyBI won’t let you create new dimensions or dimension members from external (SQL) data in the "Issues" cube. It is allowed to import additional properties to already existing dimension members or additional numerical values (measures) and map this data against one or several cube dimensions but then you can map these numerical values just to existing dimension members.
An alternative would be importing SQL data in a separate cube (in a separate account).

You can reach out to support@eazybi.com and provide more details on what you mean by "a couple of information from the Zephyr Squad" perhaps we can offer some workaround

Martins / eazyBI support