Application architecture redesign to utilize SSAS

This is a discussion on Application architecture redesign to utilize SSAS within the sqlserver-datawarehouse forums in Data Warehousing category; Hi I have an analytical application, which uses relational database (actually very close in structure to typical star schema) as underlying data store. I'd like to redesign its architecture to utilize SSAS. I've built cube which provides analytical view on data, and I'd like to replace custom data grids with OLAP type pivot tables. Now I'm wondering, how to handle situation, when user would like to execute some kind of action against cube cell. Previously, most lists provided selection methods (checkboxes, filters, etc) and some action buttons which were used to process selected items. Using pivot ...

Go Back   Database Forum > Data Warehousing > sqlserver-datawarehouse

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-13-2008, 08:43 AM
Default Application architecture redesign to utilize SSAS

Hi

I have an analytical application, which uses relational database
(actually very close in structure to typical star schema) as underlying
data store. I'd like to redesign its architecture to utilize SSAS.

I've built cube which provides analytical view on data, and I'd like
to replace custom data grids with OLAP type pivot tables. Now I'm
wondering, how to handle situation, when user would like to execute some
kind of action against cube cell. Previously, most lists provided
selection methods (checkboxes, filters, etc) and some action buttons
which were used to process selected items. Using pivot table, I'd like
to be able to do the same for selected cube cell (or - actually for
dimension members linked to given coordinates).

So general question is - where could I find some article about
methods of providing feedback from cube back to underlying relational
database?

Or maybe this should be handled by application - by manually executing
drillthrough action (or drillthrough query), and iterating over result data?

Any tips appreciated.

Marcin


Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 03:41 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.