|
|
Browse by Tags
- 11g
- 2005
- access
- ado
- Analysis Services
- Anlysis services
- AS2008
- ASP.NET
- building
- cannot
- coldfusion
- connect
- connection
- create
- crystal
- cube
- cube. calculated member
- CUBERANKEDMEMBER
- cubes
- CUBESET
- data
- data warehouse.
- data warehousing
- datetime
- dimension
- display
- drill
- Duplicate attribute key has been found (dimTime)
- essbase
- EXCEL
- Excel 2007
- file
- find
- how
- material views
- MDX
- MDX basics (members/Children)
- microsoft
- MS Excel
- MS SQL Server
- OLAP Cube / Employee Dimension / Hierarchy
- OLAP cube.... Point in time issue
- Oracle
- parse
- PERFORMANCE
- process
- project
- queries
- RAID
- RAID 0
- reports
- restore
- server
- sharepoint
- SQL
- SQL Analysis Services
- Sql analysis Services 2005
- SQL Server
- sql server 2005
- SQL Server 2005 SSAS
- SSA
- SSAS
- SSAS 2005
- SSAS 2008
- SSIS
- SSRS
- SSRS 2005
- SSRS 2008
- time
- use
- Using a named set as dimension.
- vba
- View Pivot table in sharepoint
-
Using a named set as dimension.
I used a named set in AS 2000 called R18. It contained all month members eg. 200806,200807....201001,201002. In a pivotable in Excel 2007 connected to the AS2000 cube you could see in under the Time dimension and just drag it out and put as rowheaders. It would then dynamicly change when todays date... -
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... -
MDX basics (members/Children)
Hi I've started building my first cube after finishing a book (a while ago) and I just realized that to understad better cubes I just need to learn/practise MDX basics :) So can someone explain me the difference between members and children on real life (simple) examples? My only difference after... -
Can Crystal reports query Microsoft OLAP cubes using MDX queries
I am new to Crystal Reports. Can I connect to an OLAP cube and retrieve data from it using an MDX query. What are the steps I need to take to query a Cube and create a report based on the data? Thanks, FT -
using non_empty_behavior in MDX
I have a really big query(the code I'm posting is a simple version of my original code) and I really need to have the non_empty_behavior included. The problem is that when I do, I loose a lot of data, as this function seemes to show only the values if the measure [Number Of Packages Sold] for current... -
How can I make my OLAP exectute faster?
I'm having big difficulties with an existing OLAP where the end user uses Excel to pivot the data. The OLAP has 6 dimensions where 5 of the dimension have from 34 to 2266 rows and the last dimension, has around 275.000 rows. The fact table has about 165.000 rows and around 2.500 rows are added each... -
Performance issue when using pivot in Excel 2007 on OLAP
I'm working with a OLAP cube that I want to use in excel to pivot. I need certain dimensions and facts and when I add all of those to the cube when I browse the cube in Management studio it's working very fast, but when I add the same dimensions and values to my pivot in excel, then it takes... -
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...