My fact table has a "Date" column that I have used as a foreign key to the Time Dimension table I used SSAS to create for me in the datasource. However when I deploy the cube and browse it, adding the time dimension attributes or any of its hierarchies do not filter anything on the measures. Its like there is a disconnect between the tim...
I am new to Dundas, I would like to export the olap grid to excell. I dont know how to do it. can someone help me on this? ...
Hi all, I was wondering what Palo OLAP Server handles as input Database ? Does someone know where I can find a list of the input Database supported ? Thank you ! ...
Is it possible to use our solution's existing authentication mechanism for determining access rights to a MS Analysis services cube? We already have a system that manages usage policies and we would like to avoid duplicating this on the SQL Server. Our authentication system is based on NetSqlAzMan and we could expose it as a web servic...
Hi can you recommend me some OLAP cube designer for Mac? ...
Hi all, I just installed Palo Suite 3.1 with the archive I got form the official web site. I am running Ubuntu 10.04. Once installed and logged in I got the surprise to do not have the "OLAP Server" menu. Does anyone know if there is something extra to do ? ...
Im having an issue with an MDX query, and I think it boils down to the order of precedence between calculating an aggregate and a calculated member. Let me start with the underlying data, which revolves around a valuation (which has a date, and some other data such as a member type, a scheme - and crucially for this question; a loading ...