|
need some help
hi,
tried several issues to solve this ploblem.
i want to install reporting service but during the install ill get " Error
1920. Service 'ReportServer' (ReportServer) failed to start. Verify that
you have sufficient privileges to start system services."
But im a domain admin. doing this on a new machi ...
Wed, 5 Jan 2005 14:44:57 +0100
|
Best practices for datawarehouse testing
What are the best practices for datawarehouse testing?
Where can see White papers or other resources for that?
Thanks
...
Wed, 5 Jan 2005 04:59:32 -0600
|
Partioned View issue when upadte/insert
I have a partioned view called members.
Partined based on status of the members.
Tables : members_11 ( check status=1)
members_22 (check status>1)
primary key ( memberid , status)
View: members -- create view members as select * from members_11 union all
select * from members_22
Thinks are working ...
Thu, 30 Dec 2004 10:45:09 -0800
|
How to set FILLFACTOR
I need some help on how to improve performance when loading tables.
We have a datawarehouse and sometimes it is needed that the entire
datawarehouse is refreshed. (like when test is refreshed from production)
The datawarehouse tables are refreshed by a set of sql statements. Take for
example there is a CO ...
Thu, 30 Dec 2004 11:04:02 -0500
|
OWC graph - UDF does not return a time formated value
I have a problem that doesn't allow me to build correctly a chart
using OWC (11) when I get values from a UDF (ActiveX EXE component)
that returns a time formatted value (format "0:00:00"). Everything is
OK if I use the raw data (function parameter), but when I try to get
it through the ActiveX object, empty va ...
28 Dec 2004 01:55:58 -0800
|
looking for a GIS mapping software
Hi,
I want to display some numbers in a map.
These numbers come from a data warehouse and/or an OLAP cube
I'm looking for a webbased tool.
I want to display some colors linked to some values and I want to display
specific "push pins" associated to specific postal code numbers.
The target map will be Cana ...
Tue, 21 Dec 2004 13:13:22 -0500
|
Weekly Report
Hi everybody,
When a well-know MDX statement my outcome is:
Jan Wk 1 2004 / Jan Wk 2 2004 .... / Jan Wk 4 2004 /
Jan Wk 1 2003 / Jan Wk 2 2003 ....
Product 1
Product 2
....
Select
{Descendants([Date].[Month].[January, 2004], [Date].[Week], Self),
Descendants([Date].[Month].[Ja ...
Mon, 20 Dec 2004 15:17:59 -0500
|
How To Create a Calculated Measure With Filter?
Dear all,
If I have a cude named employee,with a measure named amount. When I
select a member of date dimension, [2004].[Half Year],now the amount is 1200.
How can I create a calculated measure which equals the total amount of
employees before [2004].[Half Year]??
Thanks & Best Regards!!
Phoenix
...
Sun, 19 Dec 2004 17:35:03 -0800
|
Cube showing slightly different data than in data source...?
Hello,
I am very perplexed with this problem I'm having. I work for a website-based
company and my job is to create a data warehouse based on usage of the site.
We have a Central Logging Database that logs every single hit to the site,
then i have a stored procedure that picks up these hits, does a bit of dat ...
Fri, 17 Dec 2004 03:53:03 -0800
|
Cube showing slightly different data than in data source...?
Hello,
I am very perplexed with this problem I'm having. I work for a website-based
company and my job is to create a data warehouse based on usage of the site.
We have a Central Logging Database that logs every single hit to the site,
then i have a stored procedure that picks up these hits, does a bit of dat ...
Fri, 17 Dec 2004 03:49:02 -0800
|
Limitations of SQL Server Accelerator for BI
We are using BI Accelerator and we faced the problem that it is not possible
to insert new rows. We have some shared dimensions and when we define cubes
we also have to add list of dimensions. Very quickly we fill in the whole
space of the worksheet. The worksheet is protected and basically we do not
have a ...
Thu, 16 Dec 2004 06:35:15 -0800
|
Numerous Numeric Fields to 1 Numeric Field in New Table
Are there any routines out there that will automatically convert a table (A)
with numerous numeric fields to a new table (B) with just one numeric field.
Thus the number of records in the table (B) would be the number or records
in A mutliplied by the number of numeric fields.
Thanks in advance
220 21541 ...
Thu, 16 Dec 2004 10:35:01 -0000
|
SQL Clusters and Analysis Services DSO
Greetings,
Although this may relate more to Analysis Services administration, I thought
I'd post it here in case someone with the administrative side of Data
Warehousing subscribes to this Group.
I have a need to run Analysis Services on a single Server instance, but
obtaining its data from a SQL Server Cl ...
Tue, 14 Dec 2004 00:04:12 -0800
|
Problem with win98 clientes accessing Analysis Services through Excel
I4m with a strange problem.
Some users, that has windows 98 as their operational system, created a
XLS file to access an Analysis Services 2000 Server through Excel.
It was working without problems. But today they reported an error. When
thay refresh the Pivot Table in the XLS file, they receive an error
m ...
Tue, 14 Dec 2004 06:59:58 -0800
|
Datamart
Hi,
I need some advise. We are in he process of designing our first data
mart. This Datamart will consists of sales orders activity. Sales
orders have lines created, deleted and inserted on a daily basis as
long as the sales order is open.
It has been suggested that we do triggers the these tables and th ...
Mon, 13 Dec 2004 15:45:13 -0500
|