Writeback Values bigger than Int allows?
-
Ahoi,
i have a write Table enabled and fully functionally working, the only issue is my users need to write back values bigger than int allows.
I tried changing/drop creating the write back table to bigint or numeric, but it still says the value is out of bound when i try to write back the data bigger than the int allows.
--> updated DSV, redeployed and processed the databaseSince the table is created by the system through enabling write in this partition, i'm not sure how to make that happen, if possible.
Edit:
Random Example Screenshot from internet showing what kind of write back im talking about
ThanksI want to be the very best
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
Like no one ever was -
stupid me, the solution is as simple as it sounds
the table created by activating write back is based on values that are in the cube already, i changed the measure in the partition from int to bigint and voila, the writeback value is bigintI want to be the very best
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
Like no one ever was -
Glad it's working and thanks for providing an explanation of what worked.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply