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
 
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 ...
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...
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 ...
(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...
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...
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...
Is it possible to connect to an OLAP cube through Access 2007? If so, how?
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...
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 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...
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...
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...
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
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...
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...
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...
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.
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...
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...
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...
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...
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:- =...
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 ...
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...
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...