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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.