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 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 - Tuesday, January 8, 2019 7:34 AM

    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.

    Thanks

    Perhaps you would give us some examples showing how big these numbers are?

    What does 'write table enabled' mean? Are you talking about SSAS, by any chance? If so, you should consider moving your post to the relevant forum.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Phil Parkin - Tuesday, January 8, 2019 7:41 AM

    ktflash - Tuesday, January 8, 2019 7:34 AM

    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.

    Thanks

    Perhaps you would give us some examples showing how big these numbers are?

    What does 'write table enabled' mean? Are you talking about SSAS, by any chance? If so, you should consider moving your post to the relevant forum.

    1. up to like 100 Billion
    2. Yes i am talking about enabling writeback for a partition in the SSAS project, oh fk there is a sepate section for that
    Can i  move it myself or do i need a mod for me to do that

  • ktflash - Tuesday, January 8, 2019 7:48 AM

    Phil Parkin - Tuesday, January 8, 2019 7:41 AM

    ktflash - Tuesday, January 8, 2019 7:34 AM

    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.

    Thanks

    Perhaps you would give us some examples showing how big these numbers are?

    What does 'write table enabled' mean? Are you talking about SSAS, by any chance? If so, you should consider moving your post to the relevant forum.

    1. up to like 100 Billion
    2. Yes i am talking about enabling writeback for a partition in the SSAS project, oh fk there is a sepate section for that
    Can i  move it myself or do i need a mod for me to do that

    You cannot move posts between forums, so I suggest the following:
    1) Recreate the post in the SSAS forum.
    2) Add a new post to this thread directing people to post all replies to the new post.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 5 posts - 1 through 4 (of 4 total)

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