Hello Community,
I'm a new comer in MS DW/BI stream.
Can anyone please suggest me some good books/links on Analysis Services 2K5?
And also similar stuff for ProClarity would be of great help too.

Does anybody know why searching for a string '@' with LIKE does not work
even when you use ESCAPE
Very strange......
Say the field has .....   I love my @*&!& friend

Was looking at Kimball SSIS templates and note that when he is updating Fact
tables, he first dumps the original extract into an "extract" table, then in
a 2nd Data Flow area inside the same control flow, pulls that data and lines
it up with the dimension(s).

The company I work for track refinery capcities around the world and what to
put this data into a data warehouse. At first glance it looks simple enough,
every quarter they take a snapshot of each refineries capacity and that is
the fact table and the dimensions would be owners, ...

the customer wants to measure the time of some processes.
E. g. you produce cars:
Before the car leaves the factory their is a final control. In the control
are several

SSAS 2005.
I am trying to view the cube data from Excel through HTTP Connection
with
'Basic Authentication' ticked for Authentication method, but while

SSAS 2005.
I am trying to view the cube data from Excel through Cube data with
'Basic Authentication' ticked for Authentication method, but while
refreshing the data the account that is used to connect to the OLAP data

In my dimension I have included an attribute "CustomerName" which I only use
for securing dimension data belonging to different customers.
This attribute "CustomerName" is unimportant for the users of the dimension,
since they only will see their own name in there.

Our business is we have contracts, which one to many contractors can work
on.
I have a working cube for the contracts and 3 measures ContractFact,
ContractLocationFact, and FundingFact - all is working well.