I am trying to use Bexgetdata in analyzer but getting all value #NV when adding any new char value of key figures
Data provider - query with structure
Char Key Figures
Years Account Total Sales
If in BexGetdata function... I try to add one more key figure - Quantity - I gett all value for Quantity as #NV
is it happening because - Data Provider - does not have any information about Quantity (because its definition contains only - Total Sales? (thats what I am doubting).
Can we define whole cube as dataprovider and them manipulate whatever key figures we need in query?
... any help will be appreciated.