Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Crosstab DW with stored procedure as source

  1. Issue
0
Votes
Undo
  1. Philippe PILAT
    Philippe PILAT
  2. PowerBuilder
  3. 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.

Clear Blob Data
Saving datawindow to Excel using XLSX!
Responses (1)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 6 January 2020 23:35 PM UTC
  2. PowerBuilder
  3. # 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.