Hi,

Q1. In Cognos, there are options for join properties for star-schema, e.g
case 1: inner-join, outer-join
case 2:
Is there any similar functionality at AS?

Q2. Likewise, Cognos

Sorry for the incomplete message sent. Let me finish my previous
questions!!

In Cognos, there are options for join properties for star-schema, e.g
case 1: inner-join, outer-join
case 2: conditional joining, dim.columnB < fact.columnA and dim.columnC >
fact.columnA
Is there any similar functionality at AS?

Thousand of Thanks!

cl

"cl" <cl230020 (AT) tsg (DOT) com> wrote

Hi,

In any way you can choice any table or query from a database (Oracle,
SQL Server, Access) to have a basis for a facttable or dimension
table.

Regards, Marco

www.gmsbv.nl


"cl" <cl230020 (AT) tsg (DOT) com> wrote

Hi Marco,

Thanks!!

Could you pls explain more on designed the suggested fact/dimension table,
which could form a star schema for cube building at AS?

Best Regards,
cl

"Marco Groeneveld" <olap (AT) gmsbv (DOT) nl> wrote