0

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

Mar 23, 2017 at 12:41 AM

592

avatar image

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.

nodio.png (58.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

avatar image
Former Member
Mar 24, 2017 at 12:14 AM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0
Jan Van Ansem Mar 23, 2017 at 11:27 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 23, 2017 at 08:18 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 08, 2017 at 07:39 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 10 at 08:02 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content