Samiu2 - I would recommend to create a DTS package which processes all your cubes sequenctially, one after the other. We had a similar situation when I started - our...

Oops, meant to also mention this....I have not found any good books on AS and performance tuning. I have the Microsoft OLAP Solutions book (Wiley Press) which has a whopping...

We have basically the same process. We fully process our cubes every night after doing a daily ETL process. We have held off on incremental updates for various reasons. Partitionaing...

Good idea here. Sometimes things get overlooked and scroll off into never never land.

I think that 24 or 48 hours is too short. 5 days (or a week) is...

You would need to define a product / language relationship such as:

PRODUCT TABLE

---------------

Product ID

Product details

..etc

PRODUCT DESC TABLE

------------------

Product ID

Language ID

Product description (language specific)

LANGUAGE TABLE

------------------

Language ID

Language description

And set up the relationship as...

Yeah, a big peeve but easily ignored. If the subject is too generic and doesn't grab me, I ain't clickin'! Sorry newbies...

How about if your number of posts is <...

Anyone have any clue out there about this Alert Sev 19 error? Is there any systematic way of debugging it?

We have received another Alert on production earlier this...

Congrats! And thank God you took out that damn "Don't roll your eyes" bit. It wasn't funny the first time, let alone the 3000th time I read it!

What Service Pack are you on? Make sure it's the latest. SQL2k is extremely buggy in the mail area (even after SP2). Not sure if this helps but I had...

The Search link disappears if you are not logged in. Once you login it appears. Took me a while to notice that!

Also, the Search really sucks here. I'm not...

It's possible that it's a bug. I have been struggling with this ever since our upgrade to SQL2k. It seems to occur randomly and spontaneously. We run the same daily...

It's a table. Here is the definition (sorry if the format looks bad). BTW, I paraphrased in the first mail, the id is SALES_INDICATOR_ID.

COLUMN_NAMETYPE_NAMEPRECISIONLENGTH

SALES_INDICATOR_IDnumeric() identity1820

INVOICE_DATEdatetime2316

APPLICATION_SEGMENT_CODEvarchar66

OBJECT_CODEvarchar88

END_USE_CODEvarchar88

SUBSTRATE_TECHNOLOGY_CODEvarchar88

DATA_TYPE_CODEvarchar66

PRODUCT_CODEvarchar2020

LOCAL_CURRENCY_CODEvarchar33

TRANSAC_CURRENCY_CODEvarchar33

SALESMAN_CODEvarchar1111

CUSTOMER_CODEvarchar1515

INVOICE_NUMBERvarchar1515

INVOICE_LINE_NUMBERvarchar1515

QUANTITYnumeric1517

SALE_AMOUNT_TRANSACnumeric1517

SALE_AMOUNT_LOCALnumeric1517

SALE_AMOUNT_CHFnumeric1517

GROSS_SALES_TRANSACnumeric1517

GROSS_SALES_LOCALnumeric1517

GROSS_SALES_CHFnumeric1517

INVOICED_NET_LOCALnumeric1517

INVOICED_NET_TRANSACnumeric1517

INVOICED_NET_CHFnumeric1517

NET_SALES_LOCALnumeric1517

NET_SALES_CHFnumeric1517

NET_SALES_TRANSACnumeric1517

CHARGES_LOCALnumeric1517

CHARGES_TRANSACnumeric1517

CHARGES_CHFnumeric1517

TAXES_LOCALnumeric1517

TAXES_TRANSACnumeric1517

TAXES_CHFnumeric1517

VIEW_TYPE_CODEchar11

REBATE_LOCALnumeric1517

REBATE_TRANSACnumeric1517

REBATE_CHFnumeric1517

YE_REBATE_LOCALnumeric1517

YE_REBATE_TRANSACnumeric1517

YE_REBATE_CHFnumeric1517

PENALTIES_TRANSACnumeric1517

PENALTIES_LOCALnumeric1517

PENALTIES_CHFnumeric1517

RE_INVOICED_LOCALnumeric1517

RE_INVOICED_TRANSACnumeric1517

RE_INVOICED_CHFnumeric1517

CREATED_ONdatetime2316

PRODUCT_COST_BUDGET_LOCALnumeric1618

PRODUCT_COST_BUDGET_CHFnumeric1618

PRODUCT_CONV_COST_BUDGET_LOCALnumeric1618

PRODUCT_CONV_COST_BUDGET_CHFnumeric1618

PRODUCT_MAT_COST_BUDGET_LOCALnumeric1618

PRODUCT_MAT_COST_BUDGET_CHFnumeric1618

PRODUCT_COST_STANDARD_LOCALnumeric1618

PRODUCT_COST_STANDARD_CHFnumeric1618

PRODUCT_CONV_COST_STANDARD_LOCALnumeric1618

PRODUCT_CONV_COST_STANDARD_CHFnumeric1618

PRODUCT_MAT_COST_STANDARD_LOCALnumeric1618

PRODUCT_MAT_COST_STANDARD_CHFnumeric1618

PRODUCT_COST_ACTUAL_LOCALnumeric1618

PRODUCT_COST_ACTUAL_CHFnumeric1618

PRODUCT_CONV_COST_ACTUAL_LOCALnumeric1618

PRODUCT_CONV_COST_ACTUAL_CHFnumeric1618

PRODUCT_MAT_COST_ACTUAL_LOCALnumeric1618

PRODUCT_MAT_COST_ACTUAL_CHFnumeric1618

It was set as a Daily@7pm recorring job. The weird thing was that you could sit there and open the job properties, change it, save, open again, and it would...

Stupid question time - how do you change the datasource? I added a second datasource, but within the cube and shared dimensions editor, the original datasource is grayed out. Do...

No luck so far. Since the datasource timeout settings cannot be cahnged, is there a way to swap the current datasource with a new datasource? I can't delete the...