> Hi all,
> Is there a way to make a DW grouped by row and column. What I mean is:
> Suppose I have columns User, ObjectType, Object. So I need to
> represent this data in the next way:
>
> User1 User2 User3
> ObjType1 a1 a2 a3
> b1 b2
> ObjType2 c1 c3
>
> Where, as you understand, a1, a2... c3 are Objects
>
> Is there a way to make this?

Hi,
You know Chris, I've made this crosstab and have this problem:
I configured it as it should be, but when I retrieve data no data I
can see. When I check what data the dataobject has, it has none.
I even tried to make Importstring which returned 0, so no data is
imported, why do I get this situation?

On Dec 18, 11:28 am, "Chris Werner" <cwAT{PleaseNoSpam}f-s.de> wrote:
> Hi,
>
> I'm afraid for crosstabs you need to use retrieve(). What's wrong
> with that?
>
> Chris Werner
> f+s software gmbh
>
> <danu.o...@mail.ru> schrieb im Newsbeitragnews:f65fd968-1aee-4eb8-baa0-b0d5f981ac8e@q26g2000prq.googlegroups.com...
> On Dec 18, 9:35 am, danu.o...@mail.ru wrote:
>
> > And basically the data in the DW is populated through IMPORTSTRING, in
> > all cases! We have functions to retrieve DW through importstring!!
>
> So I found out that Crosstabs does not support Importstring. So what
> are the other methods to get data, except standart method of retrieve?

The problem is that we use another program to create a connection with
DB, so we can't use SetTranObject with SQLCA.

Can't you instantiate a second transactoin object and use that for this
retrieve?

--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com

<danu.oleg@mail.ru> wrote in message
news:0f8c565b-a277-44d4-87c6-d7c3667b639f@s9g2000prg.googlegroups.com...

On Dec 18, 11:28 am, "Chris Werner" <cwAT{PleaseNoSpam}f-s.de> wrote:
> Hi,
>
> I'm afraid for crosstabs you need to use retrieve(). What's wrong
> with that?
>
> Chris Werner
> f+s software gmbh
>
> <danu.o...@mail.ru> schrieb im
> Newsbeitragnews:f65fd968-1aee-4eb8-baa0-b0d5f981ac8e@q26g2000prq.googlegroups.com...
> On Dec 18, 9:35 am, danu.o...@mail.ru wrote:
>
> > And basically the data in the DW is populated through IMPORTSTRING, in
> > all cases! We have functions to retrieve DW through importstring!!
>
> So I found out that Crosstabs does not support Importstring. So what
> are the other methods to get data, except standart method of retrieve?

The problem is that we use another program to create a connection with
DB, so we can't use SetTranObject with SQLCA.

<phoran_remove@remove_sybase.com> wrote:
> Can't you instantiate a second transactoin object and use that for this
> retrieve?

No, cause client machine may not have Oracle Client, or event ODBC
Oracle Client Drivers, so I can't initiate a thing. The idea is that
between the DB Server and user Machine stands the Unix server, on
whitch runs an application to connect that connects to DB. So user's
app. calls functions from the Unix machine app, and gets string of
data which is imported in DW. So user machine does not initiate any
transaction, and so I need a method to make it other way.

In April 2000 we had this question here:
I have a table with 40 integer fields, with a primary key of "mo" for
month. Let's say I always have 12 rows, where "mo" has a value of 1-12.
All I want to do is display all these fields in vertical columns, 40
items tall, where the "January" column is on the far left and the
"December" column on the far right. These 'columns' actually correspond
exactly to 'rows' in the table.
Paul supplied a SQL answer, I supplied a Powerscript one. I am attaching it
here. It should be obvious that if number of columns/rows is unknown
beforehand, then datatobjects for getting the data and for displaying it can
be created dynamivcally...
<danu.oleg@mail.ru> wrote in message
news:9c122abe-0bc3-46e7-88b5-bee56a05b4d1@o40g2000prn.googlegroups.com...
On Dec 18, 3:57 pm, "Paul Horan[Sybase]"

<phoran_remove@remove_sybase.com> wrote:
> Can't you instantiate a second transactoin object and use that for this
> retrieve?

No, cause client machine may not have Oracle Client, or event ODBC
Oracle Client Drivers, so I can't initiate a thing. The idea is that
between the DB Server and user Machine stands the Unix server, on
whitch runs an application to connect that connects to DB. So user's
app. calls functions from the Unix machine app, and gets string of
data which is imported in DW. So user machine does not initiate any
transaction, and so I need a method to make it other way.