| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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 |
![]() |
| Thread Tools | |
| Display Modes | |