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'm working on MS SQL 2005, and i want to write MDX (for OLAP cube) for making "SETS" for the dates dimension: last 90 days, last month.. etc'
how and where should i write it?
thanks
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
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 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 ...
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 ...
(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...
Hi,
I'm using Microsoft SQL Server 2005 Analysis Services and have a problem with creating a date dimension.
I have a requirement that my Date dimension goes down to a granuality of seco...
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 want to make the dates in OLAP cubes (MS SQL 2005) become "real dates" dimension, that excel 2007 will recognize it as days and can filter them with its filters (months/Queters etc')
how ...
Hi,
I am new to datawarehousing and was trying my first real cube.
I have two databases on the same server and hence I have created two DS on SSAS 2005 one of the DS has fact table and man...
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 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...
Say for instance I have 2 fact tables....both are keyed on a field named AccountKey, and each contain data regarding their own set of Facts....granularity is the same, but one may contain more...
Hi,
I am using Palo and trying out the KettlePaloPlug in sourceforge to put into the Pentaho Data Integration (previously known as kettle) version 3.03.
I can't get a connection when cre...
Hi There
I am trying to import external data in Excel from a OLAP cube.
I try and conect to the datasource and I keep getting a Unable to locate server error.
Is there anything that nee...
Hi,
i have time dimmension on table that i have from 2000 untill 2010. i want the Excel user to see only the years 2005-2008 when he open's the view (see attached file for example)
i would l...
Hi,
In my cube the ParameterValue column include the monthname but not the number of the months ([Time].[Calendar Month].&[January])
Therefore I created a member with case to link the mont...
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...
I'm new to BI. I have a cube that represents motorcycle or whole unit sales. In the cube I have a calculated measure called Total Margin and am trying to create a KPI that compares where we ar...
Consider 2 tables that I want to incorporate somehow into an OLAP solution.
Customers (Customer Name, Age, StoreLocation, CurrentBalance)
One Row for each Customer
John Doe, 35, Modesto, ...
Hi folks,
I have a database table named DORGAN.This table keeps organizational information of the company. And organizational hierarch is located in a column called "Parent".
I am very new t...
We have to integrate SQL Cubes with Excel web services(in sharepoint). We are able to read the data from cubes into an Excel uploaded on Sharepoint.However we are stuck on trying to write back...
Hi all, im having a bit of trouble with my MDX in the calculated member expression box (which doesnt seem to work quite the same as MDX examples on the net).
Original MDX
([Measures].[Tota...
I would like to create a Report based on the current Month.
In the query builder i put a MDX filter on the Time Dimension:
StrToMember("}[Time].[Year - Quarter - Month - Date].[Month]...
