J Joe Feb 6, 2007 #1 Is there anyway to get access to link Cubes on an OLAP data source? I would have thought so as Excel does it nicely.
Is there anyway to get access to link Cubes on an OLAP data source? I would have thought so as Excel does it nicely.
6 '69 Camaro Feb 6, 2007 #2 Hi, Joe. Is there anyway to get access to link Cubes on an OLAP data source? I would have thought so as Excel does it nicely. Click to expand... Sorry. No. The OLAP Add-in only works in Excel, not Access. But feel free to design an Access Add-in that works the same way. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blog: http://DataDevilDog.BlogSpot.com http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. Is there anyway to get access to link Cubes on an OLAP data source? I would have thought so as Excel does it nicely.
Hi, Joe. Is there anyway to get access to link Cubes on an OLAP data source? I would have thought so as Excel does it nicely. Click to expand... Sorry. No. The OLAP Add-in only works in Excel, not Access. But feel free to design an Access Add-in that works the same way. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blog: http://DataDevilDog.BlogSpot.com http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. Is there anyway to get access to link Cubes on an OLAP data source? I would have thought so as Excel does it nicely.
A aaron.kempf Feb 6, 2007 #3 no; I think that Microsoft should provide this functionality I mean.. Crystal Reports does this?? Why doesn't ACCESS?
no; I think that Microsoft should provide this functionality I mean.. Crystal Reports does this?? Why doesn't ACCESS?
A aaron.kempf Feb 6, 2007 #4 it's not a question of an addin a Sql Passthrough query _SHOULD_ be easy to write against an Olap datasource; I mean it's OLEDB right? it's a mother ****ing bug; it's not _OUR_ responsibility to 'write an addin' it's Microsoft's responsibility to compete with Crystal Reports. -Aaron
it's not a question of an addin a Sql Passthrough query _SHOULD_ be easy to write against an Olap datasource; I mean it's OLEDB right? it's a mother ****ing bug; it's not _OUR_ responsibility to 'write an addin' it's Microsoft's responsibility to compete with Crystal Reports. -Aaron