Calculation view data preview error

[former_member693168]

When I try to execute data preview on any calculation view on business application studio (BAS), I get the error below:

The data preview only runs over single table inside a calculation view node, but if I select a calculation view node such as a projection, join, etc., the error above happens.

Thanks best regards.

[venkateswaran_k · Accepted solution]

In the business application studio (BAS) - model - when you are calling the View, - it looks like you need to pass the Parameters for the where clause of that view.

Please check the calculation view for its required parameter. (It looks like the parameters are mandatory type)

[former_member693168 · Accepted solution]

Exactly, my calculation view require parameters, but when I run the data preview the BAS is not requiring them, so, how can I set them on data preview?

Thanks.

[venkateswaran_k · Accepted solution]

The view can be called as below (sample) - use placeholder keyword

SELECT * FROM <SCHEMA>.<VIEW NAME>
('PLACEHOLDER' = ('$$ Sold_Qty $$', '120'))
   WHERE ("REGION_NAME" IN ('NA') )
   GROUP BY "NET_AMOUNT", "PROFIT";