Crosstab DW with stored procedure as source

View Replies (1)

Resolved Crosstab DW with stored procedure as source

Issue

Votes

Undo

Philippe PILAT
PowerBuilder
Monday, 6 January 2020 10:01 AM UTC

Hi all,

I wish you a happy new year.

Using PB 12.5, 2017 and 2019.

When defining a crosstab DW with a stored procedure as source, you cannot view the "column specification" panel so you cannot change anything about the stored procedure. You have to do it in "edit source".

Has anyone found a workaround for this problem ?

Best regrads,

Philippe PILAT.

NSI IT Software & Services S.A.

Responses (1)

Olan Knight Accepted Answer Pending Moderation

Monday, 6 January 2020 23:35 PM UTC
PowerBuilder
# 1

As I recall, it has been that way for a LONG time, even back in the pre-Appeon days. In fact, the issue was even more restrictive than the instance you are experiencing. I think that once a crosstab DWO was defined and saved, there was NOTHING about the source that could be changed in the DW Painter - you HAD to use the Edit Source.

Olan

Comment

There are no comments made yet.

Page :
1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.