additonal fields in view or udm

#1

Hi,

If we want to have additional database fields based on a table added in
a AS2005 cube we can add this in the udm or the sql server view. I
would like to add a date field.

Any ideas which is the best ?

Marco

#2

its the same result.

put it in the UDM if the usage is only for your cubes.

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

Quote:

Hi,

If we want to have additional database fields based on a table added in
a AS2005 cube we can add this in the udm or the sql server view. I
would like to add a date field.

Any ideas which is the best ?

Marco

#3

Thank you. It looks like that the UDM is meant to be the enduser layer
for query tools.

I used before all queries / views as source for ssas2000 cubes and now
i have the option to import the query in UDM as view or even to copy /
pate the sql code for the query / view.

It is interesting to know which solution to choice for and if there are
companies/organisations using one of the 2 solutions with + and -.

Regards, Marco

Jeje schreef:

Quote:

its the same result.

put it in the UDM if the usage is only for your cubes.

"Marco" <olap (AT) gmsbv (DOT) nl> wrote in message
news:1157365423.281356.159990 (AT) e3g2000cwe (DOT) googlegroups.com...
Hi,

If we want to have additional database fields based on a table added in
a AS2005 cube we can add this in the udm or the sql server view. I
would like to add a date field.

Any ideas which is the best ?

Marco

#4

Marco wrote:

Quote:

Thank you. It looks like that the UDM is meant to be the enduser layer
for query tools.

I used before all queries / views as source for ssas2000 cubes and now
i have the option to import the query in UDM as view or even to copy /
pate the sql code for the query / view.

It is interesting to know which solution to choice for and if there are
companies/organisations using one of the 2 solutions with + and -.

Regards, Marco

Jeje schreef:

its the same result.

put it in the UDM if the usage is only for your cubes.

"Marco" <olap (AT) gmsbv (DOT) nl> wrote in message
news:1157365423.281356.159990 (AT) e3g2000cwe (DOT) googlegroups.com...
Hi,

If we want to have additional database fields based on a table added in
a AS2005 cube we can add this in the udm or the sql server view. I
would like to add a date field.

Any ideas which is the best ?

Marco

Both are same, because it contains only query / view , no data is
materialized.

Regards
Amish Shah

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

additonal fields in view or udm

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

additonal fields in view or udm - 09-04-2006 , 05:23 AM

Re: additonal fields in view or udm - 09-04-2006 , 07:52 AM

Re: additonal fields in view or udm - 09-04-2006 , 02:30 PM

Re: additonal fields in view or udm - 09-04-2006 , 11:39 PM