Hello, I know the basics of DTSs and have been using them for a while. Now I REALLY want to learn the advanced concepts related to DTS's e.g. 1....
Hello. For strange reasons, I am now unable to backup (archive) any of the databases in Analysis Service. When I try to archive, I get a dialog box...
Hello.<br /><br />Though this is not directly a SQL related question but I could not think of some other forum to post this request. <y <br /><br...
Hi, Can I hide displaying a certain member? Hi, I have a dimension called customers having the following levels: ALL Level 1 CustType...
Hi, I took the backup of a database (called students) from one of the machine on our LAN and then tried to restore it on another machine but am...
Hi all, Suppose I know that the maximum length for my customerID field will not be more than 10 characters (95% of times this will be numeric digits...
Hello all, I have tried many things and even the worst case thing which I was trying to avoid i.e. uninstalled MSDE SP3 and Analysis Services and...
Hi, Since I am new to DTSs therefore currently I am making my DTSs in a manner where there probably is a room for improvement e.g. When I have to...
Hi, My original account on the AD (Active Directory) was Usr129 and at that time I had installed MSDE on my local box - due to which my "local...
Hi (again), This is also relatd to th example FOODMART database which comes with Analysis Services. You must have come across the neat trick that...
Hi,<br /><br />This is about the example Foodmart database that comes with Analysis Servcies... The approach used for creating the accounts dimension...
Hi, I am using MSDE and Analysis Services (lastest packs) and the same installation on the same machine has been working great for the last 18...
Hi, Using an old system, my users were accustomed to reports in which the customers were always listed in a certain order (i.e. they were listed...
This has been a funny week. things that were running just fine till last week (and for the last many months) have started giving problems despite...
The log file of one of my database has gone upto 60GB ??? I have tried to shrink the database but the log file size remains the same. Any clues how...
Hi, I came across the following article which talks about creating and using Calculated Cells:...
Untill a few days back everyting was fine but since recently my DTS which was scheduled to process a cube now fails. I looked at the detais of the...
I am getting the following error when trying to process my cube. Can someone please guide as to how this problem can be solved. Thanks Data source...
Hi, The underlying table for my Customer Dimension has these fields: CustCode, CustName, CustSateId, CustCityId, CustTypeId, CustSubTypeId I have...
Hi, I am using Microsoft Data Analyzer and am using one of the "pre-built" MDX (offered by Data Analyzer) to find the %age. The MDX statement for...
Separate names with a comma.
