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 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...
I have deployed my first analysis service cube to a database(version 1). Now I would like to make some changes to my cube and deploy it. I would like to know if I had to revert back to version...
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...
Hi, (OLAP Newbie)
I have data on several metrics. Each metric has a value that varies by region and date.
I have made a cube with 3 dims
1) Metric Name
2) Region Higherachy
3) Time
S...
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...
SQL Server 2000 Analysis Services with Excel linked to a cube. When trying to drill into a matrice - the error appears:
"Can not show detail data for that selection. If the source databas...
We are working on a data warehouse project for one of our customers. We are now towards the end of the project and have real data going into the warehouse. The database has 13 dimensions and ...
I am currently developing a data warehouse for a telecom company.
We collect several different measures (100+) from the network elements on an hourly basis.
I'm wondering what the optimal d...
We are using Excel 2003 and 2007 to access an OLAP cube via PivotTables. We are using a date diminsion and have filtered the result set within the Pivot Table to the first three quarters of t...
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,
My cube processed fine on my desktop but when I tried to process the dimension of the cubes on the VM its taking ages the VM behaviour is completely different . the dimension processing ...
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...
Hi all,
I have an SQL 2005 Olap cube that i'm using in Excel 2003 & 2007.
I recorded a macro and applied a filter, which updated instantly.
When I ran the macro i'd recorded there was a...
Hi ,
I have created a new data warehouse which has a dimension table User with all the user details like username, userid, FirstName,lastname,DOB, gender, Age etc .. and have measure group...
We plan to migrate from Oracle to SQl Server 2005. We have around 15 applications. We have parked those 15 applications in 3 schema in a single db instance.
When we migrate to SQl server wha...
