|
|
Browse by Tags
- 2005
- Analysis Services
- Analysys Services
- calculated
- click through
- cube
- datetime
- dimension
- drill down
- Duplicate attribute key has been found (dimTime)
- EXCEL
- Excel 2007
- Hide
- hierarchies
- hierarchy
- ie
- MDX
- MDX query
- measure
- Microsoft
- olap
- OLAP Cube / Employee Dimension / Hierarchy
- OLAP cube.... Point in time issue
- OLAP cubes
- Pivot Table
- Replace
- SQL
- SQL Server
- sql server 2005
- SQL Server Analysis Services
- sql server managment studio
- SQL Server Reporting Services
- SQL2005
- SSIS
- SSMS
- SSRS
- SSRS 2005
- SSRS 2008
- StrToMember
- Suppress
- time
-
Duplicate attribute key has been found (dimTime)
Hi I generated dimTime table using script I got from the web where I added custom fiscal attributes. I followed SSAS step by step book to create time dimension and hierarchies and whn I try to process it I get the followin error: Errors in the OLAP storage engine: A duplicate attribute key has been found... -
OLAP cube.... Point in time issue
Hi I come across Iwhat would imagine is rather common scenario. I have a cube with Employee hieararchy. This works fine but Hierarchy changes from time to time. I suspect there might not be one answer to my issue and will depend on users needs. What are the typical ways to approach it? Many thanks in... -
OLAP Cube / Employee Dimension / Hierarchy
Hi I have 'employee' table which has EmployeeID and SupervisorID (self-join) and I join the table to fact table using Username field as the fact table doesn't have EmployeeID. I would like to build Employee hierarchy and I have two questions: 1) What is the standard way of doing that? I presume... -
SSAS what should I know?
Hi Everyone, I would like to learn more about SSAS = understand it and I hope more experienced SSAS developers could share their knowledge :) I'm ok in understanding data sources and data source views, cubes makes some kind of sense although it details i'm still a bit lost, dimensions makes sense... -
MDX query to extract dimensions related to multiple fact tables
How do we extract Members from a Dimension related to Multiple Fact_tables using MDX in SQL Server Analysis server 2005 with WHERE condition? For example: "Company" and "Affiliate" dimension members are(a,b,c,d) and (NJ,CAL) respectively, this dimensions are linked to 2 fact tables... -
MDX - Aggregation
I´ve constructed a DimDateMonth Dimension which hold only Year-Quarter-Month values, included in this dimension is the number of working days in the current month. I have two hierarchies a) Year-Quarter-Month and b)Year-Month and an Number Of Working Days In Month attribute (bound to the key) I´ve created... -
MDX help
I have a SSAS 2005 Cube with the followind Dims: Store Date Metrics (has 4 different values: Active, Non-Active, etc) WIth a very simple fact table that has one measure called CNT, which is a simple count of things. I can browse the cube viewing the different metrics with the CNT values across Store... -
ParallelPeriod and YTD to calculate cumulative value for last year to date
Hi everyone, I'm trying to create a cube calculation to display last year to date in a report. The report uses a set to filter a Y-W-D hierarchy to display the weeks which have happened in this reporting year. On the rows I have the week number attribute and also the date attribute (so at the moment... -
Member property as Measure
I have a cube that contains a dimension called 'Project'. The 'Project' has different member properties like 'StartDate', 'End Date', 'DlvDate' and 'Customer'. I have calculated measures: 'Item Cost', 'Hour Cost', 'Comitted Cost'... -
Adding a new Dimension to an Existing SSAS 2005 Cube
Hi, Is it possible to add a new SSAS dimension to a cube that is already in production without causing a full cube process?. The dimension we wish to add is already in the OLAP database and is updated daily. We now need to add it to a cube - the problem I have is that the underlying datawarehouse data...