Skip to Content
Dec 12, 2018 at 08:20 PM

formulae to feed static source data from excel into webi without excel dataprovider

38 Views Last edit Dec 12, 2018 at 08:47 PM 4 rev

Hi Experts,

I donot want to use excel dataprovider rather use data from Excel to frame the logic in webi.

I have EmpGrp and Emp field coming from an data provider, I want to populate measure amount column values from excel source which includes the EmpGrp and Emp list of values field.

How to write a formulae logic to get Amt relevant to EmpGrp and Emp field upon any of these selections in prompt. If I run the report without prompt selection all Amt should get display .

My prompt selections are:

EmpGrp -- Optional

Emp -- Optional