May 27, 2014 at 10:47 pm
I have created some dimensions and fact tables. These dimensions has many joins and I want to use sql server table view created from these dimensions and Fact tables as my measure and Dimension. I can't get it working especially getting the Date dimensions to relate to the Fact table. I will appreciate if anybody can help me with example how to use sql server table for ssas.
May 28, 2014 at 7:56 am
Hi kdaniapam,
I would like to help you but you should be more specific and give us more details.
What is not working and why?
Of course it is a best practice, I would say a must, to create a view layer as the data source for SSAS.
Please try to be clear and give some other details,
Kind Regards
May 28, 2014 at 9:12 am
I have the attached screen a my cube model. Now I am finding it difficult getting all the relationship to work well using the DSV. But I can write a sql server table view to give me the exact report I want using a query like this.
SELECT count(FactMRP.PackageDocTypeKey) as DocCount, DimMRPOrg.Name
FROM DimMRPProgramPackage INNER JOIN
DimMRPDocumentType INNER JOIN
FactMRP ON DimMRPDocumentType.DocumentTypeKey = FactMRP.DocumentTypeKey ON
DimMRPProgramPackage.ProgramPackageKey = FactMRP.ProgramPackageKey INNER JOIN
DimMRPProduct INNER JOIN
DimMRPOrg INNER JOIN
DimMRPPMO ON DimMRPOrg.OrganizationKey = DimMRPPMO.OrganizationKey ON DimMRPProduct.PMOKey = DimMRPPMO.PMOKey INNER JOIN
DimMRPProgram ON DimMRPProduct.ProductKey = DimMRPProgram.ProductKey ON DimMRPProgramPackage.ProgramKey = DimMRPProgram.ProgramKey
GrOUP BY DimMRPOrg.Name
I cannot create a Date hierarchy but I have a DateKey in my Fact table
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply