Writeback Values bigger than Int allows?

  • ktflash

    Ten Centuries

    Points: 1000

    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 database

    Since 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
    Bildergebnis für sql server cube writeback
    Thanks

  • ktflash

    Ten Centuries

    Points: 1000

    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 bigint

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714668

    Glad it's working and thanks for providing an explanation of what worked.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply