Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Dynamic dataWindow

4 posts in DataWindow Last posting was on 2009-12-28 19:09:27.0Z
Daniel Ferreira Posted on 2009-12-28 17:48:40.0Z
Sender: 2195.4b38e7f8.1804289383@sybase.com
From: Daniel Ferreira
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Dynamic dataWindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b38ef77.22aa.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Dec 2009 09:48:40 -0800
X-Trace: forums-1-dub 1262022520 10.22.241.41 (28 Dec 2009 09:48:40 -0800)
X-Original-Trace: 28 Dec 2009 09:48:40 -0800, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90495
Article PK: 410100

Hi guys,
I'm implementing a dynamic DW, where the user will create
reports as he pleases.
I created a window, where he can choose from a list of
columns and choose de sort order.
Now I have 2 dificulties, I hope you can help me with.
First, how do I create dynamic groups (in case he marks
columns for grouping). I want to create DW groups, not group
by on the select statement, so he can see totals;
Second, if possible, how should be my approach to let the
user position the columns on the report? I can't imagine how
to get this, position the columns perhaps dragging them
around, how?

Thanks all.
Daniel at attps com.br


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-28 18:08:26.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b38ef77.22aa.1681692777@sybase.com>
Subject: Re: Dynamic dataWindow
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b38f41a$1@forums-1-dub>
Date: 28 Dec 2009 10:08:26 -0800
X-Trace: forums-1-dub 1262023706 10.22.241.152 (28 Dec 2009 10:08:26 -0800)
X-Original-Trace: 28 Dec 2009 10:08:26 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90496
Article PK: 410101

Easy answer (and probably less expensive than the time you will spend
building your own): InfoMaker. The DWs are completely compatible with PB
(same DW engine), and Sybase marketing has been known to do OEM deals. But
if you must do it by hand, I have seen it done and here are a couple of
hints.

You can group on an expression. It will be instructive to look at the source
of a DW with groups so you can see what the syntax looks like. Groups are
not easy to handle with Modify, so you will be wanting to create the whole
DW from syntax.

Column sequence can be stored as a column. The application I saw it in put
all the user's definition into tables, read them, and ground out the DW
syntax.

One other tip: that application restricted the user's SQL to a choice of a
variety of views. That allowed the SQL to be tuned so that clumsy queries
did not bog down the DB server.
--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Daniel Ferreira> wrote in message
news:4b38ef77.22aa.1681692777@sybase.com...
> Hi guys,
> I'm implementing a dynamic DW, where the user will create
> reports as he pleases.
> I created a window, where he can choose from a list of
> columns and choose de sort order.
> Now I have 2 dificulties, I hope you can help me with.
> First, how do I create dynamic groups (in case he marks
> columns for grouping). I want to create DW groups, not group
> by on the select statement, so he can see totals;
> Second, if possible, how should be my approach to let the
> user position the columns on the report? I can't imagine how
> to get this, position the columns perhaps dragging them
> around, how?
>
> Thanks all.
> Daniel at attps com.br


Daniel Ferreira Posted on 2009-12-28 18:45:19.0Z
Sender: 22b1.4b38ef93.1804289383@sybase.com
From: Daniel Ferreira
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic dataWindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b38fcbf.2575.1681692777@sybase.com>
References: <4b38f41a$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Dec 2009 10:45:19 -0800
X-Trace: forums-1-dub 1262025919 10.22.241.41 (28 Dec 2009 10:45:19 -0800)
X-Original-Trace: 28 Dec 2009 10:45:19 -0800, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90497
Article PK: 410102

Thanks Jerry,
I'll take a look at infoMaker.
In the meantime I did the group by thing. I had to parse the
string from CreateFromSyntax, look for the ")" that closed
the "table(", ignoring "(" and ")" in between.
About the layout, if we decide not to use InfoMaker, I guess
I'll just leave it the way it's generated (adding my
headers, etc).

About the info for the columns on a table, that's just what
I'm doing! =)
I present a list of tables/columns (I have the joins setup,
so that he'll be stuck with whatever I present him), he
chooses what will appear on the report, what will be sorted,
what will be grouped, all in various drag and drop dws.

Now I still have to think on how the let him choose
arguments, based on the columns he chose. Let's say he chose
a customer and a city, when he retrieves the report I'll
have to present some interface where he'll be able to supply
that info in a nice layout...

Well, thanks again, and I'll be sure to take a look at
InfoMaker!
Daniel


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-28 19:09:27.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b38f41a$1@forums-1-dub> <4b38fcbf.2575.1681692777@sybase.com>
Subject: Re: Dynamic dataWindow
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b390267$1@forums-1-dub>
Date: 28 Dec 2009 11:09:27 -0800
X-Trace: forums-1-dub 1262027367 10.22.241.152 (28 Dec 2009 11:09:27 -0800)
X-Original-Trace: 28 Dec 2009 11:09:27 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90498
Article PK: 410103

Shameless plug: http://www.sybase.com/products/modelingdevelopment/infomaker

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Daniel Ferreira> wrote in message
news:4b38fcbf.2575.1681692777@sybase.com...
> Thanks Jerry,
> I'll take a look at infoMaker.
> In the meantime I did the group by thing. I had to parse the
> string from CreateFromSyntax, look for the ")" that closed
> the "table(", ignoring "(" and ")" in between.
> About the layout, if we decide not to use InfoMaker, I guess
> I'll just leave it the way it's generated (adding my
> headers, etc).
>
> About the info for the columns on a table, that's just what
> I'm doing! =)
> I present a list of tables/columns (I have the joins setup,
> so that he'll be stuck with whatever I present him), he
> chooses what will appear on the report, what will be sorted,
> what will be grouped, all in various drag and drop dws.
>
> Now I still have to think on how the let him choose
> arguments, based on the columns he chose. Let's say he chose
> a customer and a city, when he retrieves the report I'll
> have to present some interface where he'll be able to supply
> that info in a nice layout...
>
> Well, thanks again, and I'll be sure to take a look at
> InfoMaker!
> Daniel