Not able to do data preview in calculation view

[KamalMehta]

Hi Experts,

I have created a Calculation view and the model is as follows:

Filter Expression in Projecttion DTR is as follows:

As you can see here i have 2 input parameters in my model DATE_FROM and DATE_TO so based upon the input by the end user i am trying to restrict the data using these parameters for 'INVOICE DATE'.

Model Description: Projection_1 & Project_2 consists of 1 table each. These Tables are joined in Join_1. Input Parameters are defined in Projections so exist in all the above objects in the Model. Projection 'DTR' with valid Filter Expressions based upon input parameters as stated above.

Issue: I am not able to do Data Preview in this view it is throwing the following error

I am able to see data till Join_1 but after that it is always throwing this error.

Please suggest.

Your help would be highly appreciated.

Note: I have checked and gone through with all the related post for this but still the issue persists.

Thanks

[KamalMehta]

Any inputs please....

[michael_devine]

Hi,

Does Note 1696804 help?

1696804 - SAP HANA DB: Error during instantiating calculation model

Regards,

Michael

[KamalMehta]

Thanks.

Where do i need to set the value of the input parameter used in the Model.

[KamalMehta]

Hi All,

After doing some more analysis i realized that this error is aappearning because of filter expression defined in the Projection DTR. The Filter is based upon input parameters of date as stated above.

Please suggest.

Thanks