I have got a problem! I have just installed Analysis Services, and am able to build and process cubes, however, unable to browse cubes. When I tried to browse the cube by right clicking on a cube and selecting the option 'browse data', an error message came up:'unable to browse the cube, u...more >>

To anyone who can help, I am reviewing the processes in the Analysis Manager, and I am going through the sample exercises offered by SQL Server's Analysis Manager Help. So far, every step has been successful, but now I am running into a problem. If you have the Analysis Manager ins...more >>

Hi all, I have a small question. Is it possible to create multilingual data warehouses (cubes). I have to create a Data Warehouse for one of customers who has data in couple of countries. They need to query the data according to their culture setting. Atpresent I'm using XMLA for analysis beca...more >>

We have installed two SQL Server instances on the same machine. The machine itself is rather high end, with 4GB of memory and a quad processor running Windows Server 2003. Each of the two SQL Server instances hosts a rather large analytical database. One of these databases is current ab...more >>

Hi, I am developing DTS that extract data from Oracle via Linked server. I'm using MS OLE DB for Oracle. The following error message prompted when I query to selected tables (12 tables out of 40+ tables) in Oracle. Server: Msg 7317, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' retur...more >>

i have to implement an olap server inside of different domain. these domains dont have trusts, and they can't-- i can't figure out the best architecutre here. Just pretend for a second, that this is my arch. 1) i work in a domain called happy 2) the datamart is in a domain called sad ...more >>

Hi guys, I encountering the following error whenever I try to create a new dimension in the MS Analysis Server. "Unable to count the members of the 'Area Code' level.Please check your table joins." I have check my table joins, all the valid. Also I am using the snowflake schema. How to...more >>

I have done this experiment on one of the tables. There is table called build havinf nvText Field with large no of records. I want to drop that column and recover space. These are the results I got. SP_SPACEUSED ‘BUILD’ Results name rows reserved data index_size unused 1....more >>

Hi, in a datawarehouse with SQL Server 2000, what are your recommendations for when to reindex; update stats or just defrag the indexes? Actually, I update the statistics of the loaded table in my DTS package. So, I've 1 DTS by table, and , at the end of the package, I update with a full s...more >>

My company is looking at several vendors of BI software for our data warehouse. We have never had a data warehouse before and are learning everything from scratch. Does anyone have any opinions on the following vendors... Panorama Proclarity Cognos Business Objects Information Bu...more >>

Hi, I am having a problem with my update statement for my DataMart. (Using example here). I get text file & load it into TableA in Staging. From TableA I load it into Dimension TableB as is. Therefore now I have TableA CustomerID Name City Category ---------- ---- ...more >>

Greetings, I am running into a problem where some of our tables are creating the log files to grow even with simple recovery. Everything I read says that simple recovery will prevent this. We especially notice this when we delete the rows in a large table from the query analyzer howev...more >>

When looking at the SQL online books the Period To Date Function Topic is disable and would like to see what this function does, cause i am looking in to calculation the sales figures in SQL using the Period To Date Function and The Year To Date, but both this functions are disable, is there a wa...more >>

Hi, I'm really frustrated because it appears that Microsoft Data Analyzer's support/compatibility with "standard" MDX is pathetic :( I need to calculate the following but just can't figure out the "~Aspect .... " logic which Data Analyzer uses: 1) I want to create a Year to Date total o...more >>

Sorry for the cross post but this is really urgent and I am at the end of my wits,,please can someone help. Sorry for the botheration and really many thanks in advance. Where are all the gurus :( Thanks. -------------------------- Hi, I'm really frustrated because it appears that Mi...more >>

Hi, I have made sure that on the server I am a member of the OLAP Administrator group and everything seems to go well all the way up to Design storage and Cube processing but After that I can only browse the dimensions and can see the data but I do not see any data when I browse a C...more >>

Hi! I have a large table (5 Million records) and want to make a cube with 20 dimensions on that. That 20 dimensions are from 3 other tables (150000 records, 500 records, 200000 records) joined with my large table and 10 dimensions from my large table. That tables are daily truncated an new d...more >>

Hi! I have a sqlserver 2000 (windows 2000 server) running and my machine is now too slow. So I want to buy a new one (dualprocessor) and transfer my database to that server. I have a lot of dts jobs, user, roles, rights, cubes, dimensions how could I get that all to my new server? my main...more >>

Hi, I am building datamart but I need your expert advise to update the datamart. I get text file & load it into Staging Table. From Staging Table I load it into Dimension table Cust_Staging_Table Cust_id Cust_Name Cust_Add Cust_City 111 Sam 100 St. San Jose 222 ...more >>

HI, Can I have the identity insert start from 0001 & increment it by 1. Example 0001 0002 ' ' ' Currently my identity column 'Cust_wk' starts from 1. Example 1 2 ' ' I am having a problem that I am building script for data mart but I don't get any results Using example ...more >>

I would like to change the Datasource name. Is it possible?...more >>