Re: BI Accelerator

#1

Yes it is possible - but you cannot just change the format file - you have
to make the change in
the excel workbook and "generate" the application again - or else you BI
environment doesn't know
that there has come a new column.

\Michael V.

"janice" <nis07 (AT) yahoo (DOT) com> wrote

Quote:

what if i need to add a column for my dimension...i should
change the format file corresponding to that dimension,
right? i tried that but the changes i made didn't take
effect. the new column i included was not added. is it
possible to do such changes?
thanks.

-----Original Message-----
This is a common misconception. If you look at the PAG,
you will see that
the flat file import routines are designed for quick
proof-of-concept
systems. It was our intention that, when used in
production, that you will
put your data *directly* into the staging database and
then kick off the
Master Update package. Staging your data in flat files is
for your
*convinence*. If you need to do anything more complicated
(over and beyond
mirrored file-format to staging database table), then we
recommend you write
your import load routines to place the data directly in
the Staging
database.

(I suppose there is one minor exception to this
statement. If the data
changes are so minor that you can implement them by
changing the BCP format
files, then you could still use the existing Import
packages, exactly
as-is.)

(And, the other option you have is to change the Master
Import packages so
they do something different that just bulk insert the
data into the staging
tables. In which case, again, you are wide-open in your
options. Make
whatever modifications you feel are appropriate based on
your import data.)

--
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and
confers no rights.

"Poch Reyes" <pochreyes (AT) hotmail (DOT) com> wrote in message
news:OoIAr%23nJDHA.1052 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
What do you mean? If you change the format of the
file/data that BI
accelerator staging tables are expecting, it'll cause
errors...

Poch

"janice" <nis07 (AT) yahoo (DOT) com> wrote in message
news:5b9001c3265d$2334e930$a301280a (AT) phx (DOT) gbl...
Hi,
How can I change the format of the textfiles that are
loaded in the dimensions?

thanks.

.

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

Re: BI Accelerator

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

Re: BI Accelerator - 08-02-2003 , 05:30 PM