|
Drillthrough
Hi,
While enable drillthrough on a cube. There is a option to extra add tables.
How is the relationship mananged for these table; do i need to join it to the
fact table or the dimension tables.
How to remove a table added through this option.
Thanks a lot in advance.
--
Regards,
Yash
...
Wed, 12 Jan 2005 22:47:01 -0800
|
Cube meta data on a web page
How do I access AS database meta data (cubes + properties) from an
asp.net page?
Hans ...
Wed, 12 Jan 2005 14:01:22 +0100
|
Cubes Generation error. different between MOLAP, ROLAP
I am using one cubes for my sales analysis.
When I try to redesign storage and Process the cube from MOLAP to ROLAP, it
create error with something related to fail to create index.
I didn't change the cube design.
What information I need to be careful ? ...
Tue, 11 Jan 2005 21:21:03 -0800
|
aggregation Problem
I created a cube for Inventory valuation.
Every monthend a static Inventory valuation of every item will be put in the
cubes.
1. I don't want to aggregate the value across the months;
2. If the user view by year, I would like to system to put the Latest
valuation in that year. for examples 2003 = 2003/Dec, ...
Tue, 11 Jan 2005 17:15:01 -0800
|
Software for connecting to a remote SQL Server
Hi All,
I would like to be able to connect to a remote SQL Server and fire arbitrary
queries, browse tables, and so forth. Very much li ...
Tue, 11 Jan 2005 18:45:52 GMT
|
Odd Leaf Error
Problem sorted thanks
>-----Original Message-----
>Dear All
>Currently runningSQL 2000 Standard
>I have a parent - child dimesion called Employee where
the
>I have a member key of called Employee_ID which has an
int
>from 1 to 5, and a Parent Key which maps to the
>Employee_ID called manager ID.
>
...
Mon, 10 Jan 2005 09:22:07 -0800
|
Divide measures value with dimension value
I need to create a new calculated member, but I need to divide a measure with
a dimension member (or properties).
Sample
[Measures].[Val1] / [Locales].[M2].currentmember (no work)
Can you help me please.
--
Tomas ...
Mon, 10 Jan 2005 05:47:09 -0800
|
Odd Leaf Error
Dear All
Currently runningSQL 2000 Standard
I have a parent - child dimesion called Employee where the
I have a member key of called Employee_ID which has an int
from 1 to 5, and a Parent Key which maps to the
Employee_ID called manager ID.
I added it to the fact table that contains the Employee ID
pro ...
Mon, 10 Jan 2005 03:44:58 -0800
|
Degenerate dimensions from fact table
Hi!
We are building a star (sales) based on data from an old unix ERP
system. The transactions from this system contain all metadata normally
fetched from seperate tables like customer and article data. In
addition it has this data in seperate files. So our transactions look
something like: CUSTOMER_NR, CUST ...
10 Jan 2005 00:56:42 -0800
|
one to many relationship in a cube
Hi,
I have a cube where the products we get for repairs under warranty are
analyzed. My dimensions are repair date, symptoms, root cause and products.
All this works fine my only problems is that I need to put in another
dimension called actions (things done to rectify the problems). The only
problem i ...
Fri, 7 Jan 2005 11:27:28 -0500
|
errors processing cube
i'm facing some difficulties in trying to process a 3 dimensional cube.
Everytime i try to process this cube it'll complain that "A member with key
"(something)" was found in the fact table but not found in the level
(dimension level's name) of the dimension (dimension name)
anyone got similar experience i ...
Fri, 7 Jan 2005 23:52:42 +0800
|
Tools to test data warehousing
What are they?
...
Thu, 6 Jan 2005 20:36:14 -0600
|
Problem Transact-SQL Statement
I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for using the quotati ...
Fri, 7 Jan 2005 00:54:25 +0800
|
Veritas Backup
My network administrator set up all of the server backups using a Veritas
client to back up my sql server 2000 database. When I looked at the database
today after a couple of months with no sql server backup it shows the last
backup date as September 2004, and the size is over 20 GB.
Does anyone know if a ful ...
Wed, 5 Jan 2005 11:31:09 -0500
|
Connectivity between SAP (CO-PA) and SQL Server
Hello,
I need to extract data from the CO-PA module of SAP (Oracle DB) to SQL Server.
I would like to know what technics would apply best ?
* DTS using ODBC, but underlying SAP data structures seem undocumented,
* SAP.NET ?
* are there ways to export CO-PA data to a flat file and then bcp ?
Thank you fo ...
5 Jan 2005 08:07:14 -0800
|