I have a report date dimension, that is one level with no "ALL" level. One you open the cube, it defaults to the most recent report date. For some new calculations, I would like to build some calc mems that will get some data one month past as well. So if I am looking at my current actives,...more >>

Hello, I'm learning to use SSAS and tries to play with DataMembers in parent child dimensions. I see the effect of NonLeafDataHidden/Visible, but specifying a string for MembersWithDataCaption does not seem to has any effect. The documentation says that the value of this Attribute Pro...more >>

Hi! Do you know any tool ou method to help the migration of an entire DW repository in SQL Server 2000 to Oracle? And I mean the Dtata Transformation Services too... I think it is veru difficult to migrate DTS to DML in Oracle, but who knows there is some tool that transforms DTSs into PL/S...more >>

I have tens of thosands of records needed to be insert to SQLserver on each query. My experience is that each 10 thansands records needs 7 sec. Is there any method to increase the speed? (I am writing ASP.NET + SQLserver application) ...more >>

I am building a fact table containing 6 measures. For about 90% of the rows, 3-4 measures will be zero. What is the best data type to use for the measures? ...more >>

A requirement of our DW project is that we store Dimensional changes, and it appears the SCD Type 2 method sounds best for that.... But say you have 30+ Dimension tables, all SCD T2. Another requirement is the users can do Ad-Hoc reporting, where they could potentially join many of those Dimens...more >>

Heres my scenario: I have a dimension which has levels. For example, I have this: 7ZZZZ 70ZZZ 71ZZZ 72ZZZ 73ZZZ And I need to make a calculated cell which will zero out all the decendants of 7ZZZZ EXCEPT for 73ZZZ, using the calculated cell builder. There doesn't seem to be,...more >>

hi, this is srinu. my questions r 1) what is lookup transformation and in which situation we use ? 2) what is difference between static and dynamic? i am awating for your earlier rely. bye, srinu ...more >>

i need to do create reports that perform queries where the results are percentages of total count divided by counts based on different subquery where values. a la ... select 100 * (totalCount/ (select count where columnA value is x) as partialCount1) as perc1, 100 * (totalCount/ (select co...more >>

Hi, I am currently deduping a data warehouse containing around 3 million records. Most of my dedupe scripts run in 3 or 4 minutes but the scripts which compare datetime fields take up to 3 hours. I have a non-clustered index on the date column. Can anybody offer any advice on how I might impr...more >>

I've built a cube with a numerical dimension in SQL 2000 analysis services. When I add that dimension as a column, it sorts as follows 1 10 100 2 20 instead of 1 2 10 20 100 I've tried doing a sort in Excel 2003 and 2000, even setting the type as Number. In Analysis servi...more >>

Hi, i Studied Both Relational and Multidimentional model for Data Warehousing, but i don't know which is the best to do? can u Please Guide me? Thx -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-data-warehouse/200601/1...more >>

Is there anyway to find how many users connected to cube thanks Kalyan ...more >>

Dear All, Hope anyone can give me ideas on how to solve this problem. I have a cube with some calculated measures. The application that access this cube uses query-scope calculated member, for example to get the the cancer incidence rate per 100,000 in 3 counties, the query would be: WITH M...more >>

ANy body can Introduce me a White Paper about Granularity Manager, or A tool for this Purpose? -- Message posted via http://www.sqlmonster.com...more >>

Hi All We are having problem on indexed views when we try to join to more than one table that is not part of the original indexed view in a query. Has anybody seen a similar problem? Thanks Atholl See SQL examples below: --New Indexed View - fact table grouped by three columns, no j...more >>

Hi all, SQL 2005 SP3, AS 2000 I have a cube that is processing but is not showing any data when I browse the data. The fact and dimension tables have data and there are no null measures or fields in any of the tables involved. It will process without any problems. Has anyone come across th...more >>

Hi , I am planning to do datawarehousing and develop some cubes but i am not too sure of how to use MDX queries . Where can i get help on MDX queries ? appreciate ur advise tks & rdgs -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-da...more >>

We are currently using VB to create order numbers. Each user requests an order number as and when required. The problem is that the next in the sequence seems to be allocated on the odd occasion to more than one user. This being due to the requests coming at almost the same time but not as yet...more >>

Currently we have 5 systems that I am copying data from into my datawarehouse. The table structures are all identical in that each system has a primary key on uniqueID (int, identity) When replicating the data into my datawarehouse I am attaching a systemID (int) that uniquely identifies where...more >>

Hi, which DMBS Do u Prefer For a DW? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-data-warehouse/200601/1...more >>

Hi, I'm doing a course in datawarehousing. I need some dataset to make a project. Does anyone know where in net can I find datasets appropriate to create datawarehouse? Thanks all ...more >>