Missing field in Output Port for BI Query in VC

[Former Member]

Hello Experts

we are creating a complex VC Model. Therefore some BI Queries are necessary.

If I fetch the data service into the storyboard some fields in output port are missing.

The Query is using complex structure.

I have read note 936768 so far - Is this problem still actual ?

Thanks

[Former Member]

Hi

according to the note, component verison is spstack 08. please find your spstack and 2004s comes spstack 14 as default.

please validate and analyze your problem according to the note

Note 1225604 - Missing data from BI Query in Visual Composer

regards

nag

[Former Member]

Hello,

I also read this note - but I am just designing my model. It has not worked before.

If I change the query with using no structure everything is ok - all fields are available.

But this is no option - because we would have to do a lot of work in BI again.

But If I use a structure within the query only the fields without structure are shown.

Perhaps BI Kit is missing - Could this be a problem ?

[Former Member]

Hi

If you are using Structure in BI query then it will come as the name structure only & not the Selections/ formulas in the structure. I am assuming you have done this correctly. Or you are not getting anything like this in the query. Just right click on the query & check whether the structure is coming there or not.

Just check one thing, If you your structure is with key figures & if it is in the rows, then you will not get this structure in the 'Chart'. For this you need to create structure in the columns only.

Regards

Sandeep