Search results for query: *

The problem has been solved after a hint from someone. The PTD calculated field was build on a [Time].[Year - Month] hierarchy. But I was filtering the data using two filters. [Time].[Year] (works ok) and [Time].[Month of Year] that caused the problem.

I've created a PeriodToDate calculated field in my cube to add the sales of a product from the start of the year and I'm using a Time Hierarchy Year-Month to show it. The calculated field has no empty behavior field. I left it blank. I have the following problem. Lets say I have 2 products A...

Hi All, I am new in SharePoint development and I am trying to make an intranet site for the purposes of my company. I have managed to add sites in my primary site collection and eventually create a site hierarchy but I have to navigate to a level in the hierarchy in order to find the next level...

Hi All, I have created several sites experimenting on SharePoint 2007 and its functionality and I came up with some questions I could not solve by myself. In an early site construction I was able to add a PerformancePoint Dashboard Item web-part on the site and load on it reports, scorecards...

Thanks for your answers. I did go with the one table approach for the time being. As I'm new to SSAS I will try to balance ease of use and end user ease of use. I'd like to have all data in one table as long it does not give problems to end users when trying to do their own reports.

My question is about the fact table. Can I go with only one fact table or do I need a second one? I’ll try to explain it with an example. I’m in a hospital and I need to have the following data per clinic: (all the data are in day basis) (A hospital has many clinics). 1. Number of incoming...

Thank you all for your answers. I'm thinking of going the way creating one record per customer per day. So if I want to give access for others to get data it will be more easy.

Thanks for your answers. I want to give more information so if you can help me get the best solution. The situation is like this. The table in the OLTP has customers (patients) with arrival date and departure date. I need to know how many customers I had a year, half year, quarter, month, week...

Hello, I'm new to Data Warehousing. I'm building an BI application and I'm having some problems. My fact table has records with no specific date but with date from date to period. Let's say I have customers that come on a date and leave on another day My fact table has records like this...