Writeback Values bigger than Int allows?

  • ktflash

    Right there with Babe

    Points: 777

    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

    Right there with Babe

    Points: 777

    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: 714078

    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