question

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 asked IsmailCassiem-3967 answered

SSAS Cube Wrteback to Simulate a GUI to maintain a master table

Good day,

i have been struggling to find a free web gui for users to maintain a sql table

running out of options and thinking of using a writeback cube
using sql14, few years back i looked into doing dimension writeback but it didnt work well

perhaps using normal measure writeback users to edit measure with the dimension code?

dont know, think its silly but have no other options

any ideas please?

sql-server-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @IsmailCassiem-3967, are you mean that you are trying to let users maintain a table in SQL Server side? As I know, if you write-enable a measure group, end users can change cube data while they browse it, where changes are saved in a separate table called a writeback table, not in the cube data or source data. So it seems that this option cannot help you to maintain a SQL table.

Please let me know if I misunderstood your question.

0 Votes 0 ·

1 Answer

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 answered

Hi,
Thank You, i thought if i could edit the dimensions via a writeback and in the background have an agent job to update from writeback table to the dimension table

regards

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.