| Thread | Last Post | Replies |
|
| Newbie in MS BI | 30 Jun 2008 11:15 GMT | 2 |
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.
|
| TSQL - LIKE search statement for a '%@%' | 29 Jun 2008 16:02 GMT | 2 |
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
|
| Fact Tables | 23 Jun 2008 23:59 GMT | 4 |
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).
|
| Slowly changing fact table? | 21 Jun 2008 19:24 GMT | 1 |
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, ...
|
| How to design a cube to process "several status of a business proc | 18 Jun 2008 14:53 GMT | 4 |
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
|
| OLAP access from Excel through HTTP Connection | 18 Jun 2008 11:02 GMT | 1 |
SSAS 2005.
I am trying to view the cube data from Excel through HTTP Connection
with
'Basic Authentication' ticked for Authentication method, but while
|
| OLAP access from Excel through HTTP Connection | 18 Jun 2008 10:48 GMT | 1 |
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
|
| How to hide a dimension attribute | 13 Jun 2008 16:57 GMT | 1 |
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.
|
| many to many cube woes | 01 Jun 2008 02:28 GMT | 1 |
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.
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread