I'd like to use coldfusion to front-end an OLAP data cube. The cube is already set up, and updates nightly. It resides on an MS SQL server, but NOT running in analysis services. The cube is simply a separate database. Has anyone here had any similar experience, our could provide some pointers? I have solid experience with coldfusion, but am wondering if there is a good methodology or best practices for interfacing with the facts/dimensions. Any help is appreciated!
check out this link.
it may helps