Hi,
I am currently creating an OLAP cube in SQL Server 2005 Analysis Services.
In my source data there are 3 DateTime columns (Started, Finished, Other)
I want to model these as dims in my ...
Hi Folks,
I have an SQL Server Analysis Services OLAP data cube. Is it possible to retrieve data from this cube and also present it in an ASP.NET page?
Any idea?
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...
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...
I have a cube with a Project and an Offer dimension. There is a one to many relationship from projects to offers. The client's reporting application is excel and it appears that you can only...
Hi all,
I work for a bank in a Marketing team. I have to build a data mart for their business and cubes based on that. they use SAS mostly to do their analysis. My plan is to build this ...
Does anyone know how to develop a calculated measure using the XIRR function within Analysis Services. This function exists within Excel but that will not work as the calculation must be perf...
I restored a database in SQL Analysis Services from a backup of another server in order to use the OLAP cube from a different server. However, I can't find out how to change the Data Source ...
Hi All,
If I have a dimension (renewal letter) with a measure (renewed) and the following from a cube;
Renewal letter 1 2 3 4 5 6 Total
Renewed 20 11 3...
Hello
We are upgrading from Microsoft SQL server Analysis services 2000 to 2005. Our ETL solution will incrementally update the product dimension and the changes are visible in the related ...
Hello,
I'm trying to build an accumulated time hierarchy like the following:
per January = January
per February = January + February
per March = January + February + March
...
Is t...
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...
I have a value prompt in a prompt page and passing some periods into that value prompt. If I select some period in that value prompt..I want to display the data as actuals for the periods less...
Hi, We have to olap databases (live and development). I wish to refresh the dev olap cubes with the live ones. Could I just do a restore of live cubes on the dev box?..how does this affect the...
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...
Hi,
I am writing a VB NET application in order to retrieve all the objects from an analysis services cube or perspective.
I am using the Adventure Works DW for the tests.
I was deploy...
Hi Friends,
I am using Analysis Services 2000 of SQL SERVER 2000. I have a Cube wherein i have dimensions with following Heirachy:-
Activity
PartNumber
Now if the person selects Acti...
i have cubes on SSAS. do i need from time to time (or daily basis) to clear memory? i ask because i see decline in the performance.
this is even tough i have agrregations working.
if so - ...
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 ...
We have a server running Analysis Services and clients using Excel to access data from the cube. After a few users logon and start using the app to retrieve data from the cube the CPU usage s...
Hello,
I have the following scenario in MS SSAS 2005:
- One Measure Group called transitions;
- One Measure Group called actions;
The transitions have actions associated. They share ...
I have a dimension that has dates (m q y). The fact table has dates and null values. When drawing a cube I am getting inaccurate results because of the nulls. How do I get around this problem?
I need to do a NON EMPTY CROSSJOIN where I need to return data from multiple levels of 2 dimensions. When I try to run this, I get this error "Formula Error - duplicate dimension across (ind...
Hi All,
I am new to Datawarehouse and on my first project where I have 7 dimensions and 3 measures. The databases are very large in its terabytes. out of 7 dimensions I have 4 dimensions t...
We have built a cube using 2005 Analysis Services using the option building without a dataset. We filled the datamart that the cube designed with 100,000 records for testing and the cube buil...
