Is it possible to change the size of a datacolumn of an attribute without changing the underlying table structure?
I am having a peculiar problem. The cube that I am currently using, earlier used to throw errors while processing. It was handled by converting them to "Unknown" while processing. The reports were then designed keeping this "Unknown" issue in mind.
Just 7 weeks back, I resolved this issue. It was a referential integrity constraint issue. I inserted a default value in the dimension tables in the DSV where ever there was empty spaces. So, now the cube is processing fine. It throws no errors.
The problem is with the primary key. It is of size 6, so the default value had to be size 6.But my client doesn't want to re design the reports. They want the changes in the cube itself. That means the default value(primary key) must be "Unknown" and not some other value I put.
And I am unable to change the size of data column from the DSV.Any teeny weeny bit idea on how to go ahead on this?
I am not exactly clear on why you would want to change the size of datacolumn, although what you can do is to keep the Name as Unknown wherever the code is the default value that you have put. The ID can still remain as the default value, this way the client would be seeing the name that he wants (which is unknown) but the key would be the default value.
If you were already using the ID as the key and there was no Name column specified, then the ID itself would be the Name. So you might have to make a new column in your DSV which would display Unknown if the key is the default value, and then use this new column for the Name field.
If this is not what you want, please let me know what are the fields that you used for Name and ID before this problem and after.
It's "continuous", not "contiguous". Not a lot of value added overall.