Unable to use HANA Decision Table in data preview or Calc View

[Jan_van_Ansem]

I have created a decision table. The data foundation is a HANA table.

It activated okay.

I can see the stored procedure and execute it using:

call "_SYS_BIC"."DEV_JAN/DT_TEST2" (?);

That gives me the expected result, but:

- I cannot use the 'Data Preview' option, this is greyed out (as per screenshot above).
- More importantly, I cannot add the Decision Table to any Calculation View.

Now I did find note 2323175 which says

"Use of decision tables as a data source in calculation view has been removed" and

"Addition of decision tables with drag and drop has been removed"

So now I am completely stuck and confused about the above.

Does this mean I cannot use a decision table in a calculation view at all? Or can I only use it in a scripted view, by calling the procedure?

I have no problems creating and running calculation views without Decision Tables...

Thanks in advance for your help.

[lucas_oliveira]

Hi,

I know this does not fully answer the question but there's an option to migrate the Decision Table once you check it out from the SAP HANA Development perspective. This will generate other information models (such as table functions) based on the DT and those can be used on CVs. This info came from the official SP12 documentation

Can you give that a try?

Regards,

Lucas de Oliveira

[k_gorin]

I managed to add decision table to calculation via projection node. Why data preview is disabled is beyond me... I check my HANA Studio (v. 2.3.17) and I don't have "Migration" option.

[Jan_van_Ansem]

I managed to add the decision table to another calculation view by adding a projection first, then use the option to select the base object for the projection. This opens a search box and, after a long wait, this came back with my Decision Table.

The calculation view is still not working though, but that seems to be down to privileges so hopefully I get that sorted tomorrow.

[Former Member]

Hi,

In my case when I created decision table. It created three objects.

• Procedure ("_SYS_BIC"."Package/Decision_table")
• Table Type ("_SYS_BIC"."Package/Descion_table/TT")
• Sciprted View ("_SYS_BIC"."Package/Decision_table/RV")

So I can able to add scipted view to calculation view and further use it.

Regards,

Kalpan

[Former Member]

The work around is to use the decision table procedure that is generated automatically after the decision table activation in an SQL script calculation view. The SQL command is like :

call"_SYS_BIC"."directory/DECISION_TABLE" ( var_out );

Be aware that the columns of the SQL script calculation view should be identical to decision table output.

Then it is possible to add this SQL script calculation view to a projection.

[Former Member]

I am also stuck in this. Right now I am using the older Hana Studio version to add the decision table and using it in the current version.

I would also want to know why this feature is removed and what is SAP's suggestion on consuming decision table in calculation view.