Experts Exchange

1. srnar65,485
2. agandau53,200
3. rob_farley10,600
4. garycris9,600
5. PedroCGD9,200
6. Auric19838,550
7. pcelba8,000
8. rrjegan176,900
9. RWrigley6,400
10. sysdba6,000
11. r_guerreiro4,000
12. Hwkranger3,620
13. mrjoltcola3,500
14. tbsgadi3,325
15. boag20003,000
16. RiteshShah2,875
17. EugeneZ2,800
18. ltlbearand32,500
18. jbfraser2,500
20. udayakum...2,375
21. stelth2402,000
21. folderol2,000
21. WarCrimes2,000
21. mikeada2,000
21. dbaduck2,000
21. jimpen2,000
21. zephyr_hex2,000
21. sirah2,000
21. HoggZilla2,000
21. mfreuden2,000
21. mSharfi2,000
21. selva_ko...2,000
21. Q-rider2,000

1. srnar114,785
2. PFrog91,959
3. agandau53,200
4. PedroCGD38,760
5. RWrigley36,356
6. garycris21,600
7. rorya11,700
8. rob_farley10,600
9. neerajsoni10,000
10. CSLARSEN9,300
11. sujith809,200
12. Auric19838,550
13. mahopman8,272
14. pcelba8,000
15. Devil6667,750
16. rrjegan176,900
17. Einstine986,600
18. sysdba6,000
19. schwertner5,750
20. zorvek5,000
20. boag20005,000
20. vadimrapp15,000
23. EugeneZ4,300
24. mlmcc4,000
24. nicolasdiogo4,000
24. bahmane4,000
24. r_guerreiro4,000

Showcase your knowledge about Apple's newest OS. Write a how-to or share a tip or trick about Snow Leopard and earn unlimited points!

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

Time Tested OLAP Solutions: 1 - 25 of 110

If statements in a SQL View or Query

Hi There I have a SQL Query Select Amount,TransactionType from Transactions I want to put a condition statement in the Query where if the TransactionType=Collected put the Amount field ...

Data extraction from Hyperion Essbase 9.3.1

My company is running Hyperion Essbase 9.3.1, and my infrastructure team is looking for potential solutions for querying data from an Essbase cube in a fashion similar to the Excel Add-in, but...

Converting DateTime to Date in MDX

Hi, I have a calculated measures which is a converted to member with strToMember. This returns a dateTimr field in string format. I need to convert that into Date only (no Time). How can I ...

Create OLAP Cube by VBA and cretae Reports by ADOMD MDX

(1) I want to create an olap cube (offline) using VBA code which will get data from MS Access.If I am using the OLAP wizard to create the cube it adds ALL level to every dimension by default w...

Data Warehouse Design, Fact table with 40 attributes

I am designing a data warehouse for a telecoms company. I have read several books and articles on data warehousing including Kimballs book on Dimensional Modelling and come up with a draft des...

How to sum over time period in MDX

I got time dimension based on DateTime column in fact table. Now i'am trying to build MDX query to sum fact rows on custom time periods. For example: SELECT [Events Count] ON Columns, [20 s...

Connect to OLAP cube through Access?

Is it possible to connect to an OLAP cube through Access 2007? If so, how?

If Statement Calculated Member MS Analysis Manager MDX

I am trying to write a simple Iif statement for a cube in MS Analysis Manager. I want to check a level of a dimension and return measure values based on that criterion. Here are a couple of...

MDX - Running Totals and Percent of column calulations

Hi there I'm looking to create a report that will replicate the following Excel example in our third-party OLAP application. I'm struggling to work out the syntax that will enable me to de...

I cannot establish a connection to an internal 2005 SQL server from my workstation running Excel 2003

I have a 2005 SQL server running in my internal network. I am trying to establish a connection to it from Excel 2003 running on my workstation. In Excel I select Cube Analysis menu, Manage Con...

MDX calculation of % of total not responding to filter

In my cube, I am trying to find how a measure value relates to the sum of values as percentage (% share of total). My MDX query below parses, but doesn't account for the WHERE clause - I want...

Error Handling in ETL, using SQL LOADER and PL/SQL

Hi, I need to design an error handling framework for an ETL engine which uses SQL Loader to load data to staging tables, and uses PL/SQL procedures to load data into the warehouse, and jav...

How to convert datetime to date in a mdx query ?

Hi, I am building a mdx query including date fields and I need to show it in DD/MM/YYYY format. I don´t want to show the time..!!! How can I do it? Thanks in advance, Luis

A definition for "Dimension" in Analysis Services / OLAP

Hello: In the Glosary of the BOLs of the SQL Server 2005 you can find the following definition for "Dimension" in Analysis Services: "A structural attribute of a cube, which is an organ...

SSAS How to aggregate percentage calculated measures

Hi Everyone, I have a cube which contains vehicle movements. I have created a calculated measure in SSAS to give the daily percentage by vehicle for driving time and stopped time. The calcul...

Building Time Dimension from an fact Table in SQL 2005 AS

Dear EE members, We have a warehouse database (in SQL Server 2005) and currently we are trying to build a simple cube out here just for testing. SQL Server 2005 comes with the tool BI...

OLTP vs OLAP cube

I am going to be making a SSAS cube out of an OLTP database. Appart from performance is there any other benefit if I used an OLAP database.

MDX Where clause

I need to create an MDX query and have no idea how. One of the measures in my cube is Total Revenue. It is a sum aggregate of UNIT_PRICE that is in the fact table. What I need to do is coun...

Automating the cube using SSIS

Hi All, I am new to using SSAS 2005 I am trying to automate the cube processing using SSIS. My steps include 1. Populate the dimension table on regular basis and process the dimension 2...

analysis services - hierarchy from more than one dimension.

new to analysis services 2005. I have got a fact table which is linked to various dimension tables. I would like to create hierarchy from one or two dimensions: For eg: Daily Accounts Fa...

Sort order in MDX returned results

Hi Experts, I have this question regarding the sort order of MDX query. I did the example (attached doc) on AdventureWorks cube. Question: 1. Does anyone know what is the sort order fo...

MDX Date Range in Excel

Hi Everyone, I'm using the CUBE functions in Excel to query my SSAS cube. I have a CUBEVALUE function and I'm trying to get the value of a measure for a specific date range, like this:- =...

MDX - Filter calculated member results by dimension issue

Hi there... I'm failry new to MDX so please bear with me... I have a fairly simple cube that has as dimensions: AppealCategory, Appeal ID and PackageID. All of these dimensions relate ...

Multiple Fact Tables

So, if I have multiple fact tables in my cube, and they share the same dimensions, what is the best practice for the dimension in the cube? Should I add a view for the dimension so I can link...

OLAP Tutorial or book or ebook

Hi I am looking for one good book on OLAP. ebook or hardcopy, please suggest me some good books, I am begginer in olap. This is straight forward question, where I can get the good tutori...