Sqlserver licenses
Mon, 7 Jul 2008 01:35:03 -0700 (PDT)
Is it necessary to install sqlserver cal licenses on the server
machine.
We have purchased sqlserver standard edition with three cal
We have installed sqlserver standard edition on a windows 2003 server
machine and are experiencing problems with connecting to the server.We
experience intermittent problems wh ...
|
Measure Group with mixed aggregation
Fri, 4 Jul 2008 05:15:01 -0700
What is the best way to handle the situation where a measure group contains
some measures which are summed and others which have AggregationFunction set
to "None"? I would instinctively split these measures into two separate
measure groups to exploit aggregation. Is this a reasonable approach to take?
...
|
Change Managment / PreStaging DB
Thu, 3 Jul 2008 08:26:43 -0700
Had a question about how folks are managing "change management" on their DW
projects. One of the biggest problems we face on the DW, is most of our
data sources have separate ongoing development and rework of their systems.
So we have to be very communicative on change. If a system changes table
structure ...
|
Does not return Warning message
Tue, 1 Jul 2008 12:20:03 -0700 (PDT)
According to the below article there should be 2 error messages on the
Attribute Key not found in fact table. http://support.microsoft.com/kb/922673/
I am trying to parse the Error message 2 using AMO script to retrive
the dimension name.
In Microsoft SQL Server 2005 Analysis Services, you try to pro ...
|
Newbie in MS BI
Sun, 29 Jun 2008 23:50:00 -0700
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.
Another help needed. Does anybody have the dumps or any other reference
material for 70-445?
Kind Regards, ...
|
TSQL - LIKE search statement for a '%@%'
Sat, 28 Jun 2008 22:47:26 -0400
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
And I want to SELECT this row when I search for @ with LIKE
Select * from myTable where myField like '%@%' does not work
Select * from m ...
|
Cognos
Thu, 26 Jun 2008 08:54:15 -0700
Anybody using Cognos and have comments on it? Our shop is using SSIS, SSAS
and browsing cubes with Excel 2007. But Cognos tool looks like it may be
easier for our users.
...
|
|
|
Performance Point
Thu, 26 Jun 2008 07:51:18 -0700
Does PP actually take care of our ETL process? I always thought I would
have to populate the DW then PP would take it from there. The training
videos are sort of suggesting something else.
...
|
Dimension design question
Wed, 25 Jun 2008 07:58:00 -0700
Hello,
I have a question of dimension design. There are two taxes ISS (tax on
services provided by company or individual) and IPTU tax on property.
From a Dimension Person (containing company and individual) there is a need
to identify the property (IPTU) and each member of a company that paid ISS.
The q ...
|
Metadata
Wed, 18 Jun 2008 09:37:21 -0700
What are folks using to manage your metadata? We were thinking of possibly
coming up with something custom to manage all our 10 to 12 different data
sources for our data warehouse. I tried to make use of the extended
properties when using Kimball templates but am finding it hard to manage
updates. The Ki ...
|
