December 26, 2010 at 2:06 am
I try to create a drilltrough action. Everything works fine I can drilltrough on all aggregatble measures.
Only when I want to add a product describtion I only reveice error messages like:
" Error in metadata-manager. Datatype is invalid because it´s a string."
(I tried to translate the message from german, so please be forgiving that´s not the exact text!)
Once I got the cube working, but then I had doubles.
I´m getting nuts, until now I could do everything on my own, but this "problem" is getting me to my limit!
Anybody who can help me or give me advice?
Merry Christmas,
Holger.
December 27, 2010 at 5:10 am
You don't say where you are trying to add this to or from. Assuming you are adding the item in the SSAS BIDS, and that the item exists in a dimension, I would suggest that you check the dimension in which this information appears to ensure there is not a data type mismatch.
If the assumption is not correct, please provide additional information.
Viele Details sind nicht eingeschlossen worden. Vorrausgesetzt, dass Sie die Sache in SSAS BIDS hinzufugen und sie in einem Dimension vorhanden ist, schlage ich vor, sie im Dimension zu ueberpruefen, um zu bestaetigen, dass die Typen stimmen.
Falls die Vermuting falsch ist, bitte melden Sie sich mit weiterer Informationen.
December 30, 2010 at 1:27 am
So far you´re right.
I created a dimension called stock. In this dimension is a field called piecenr which is a wchar.
Now I added the field piecenr to the measures. Here is my first problem, I need to configure a aggregationfunction, and I have to configure NONE, everything else makes no sense.
Then I created a drillthrough action.
December 30, 2010 at 2:48 am
You don't explicitly say that the problem has been solved, but there doesn't seem to be a question in your comment. Would you please clarify if there's something further that you need?
Es ist mir nicht klar, ob das Problem nun geloest ist order dass weitere Hilfe benoetigt wird. Bitte geben Sie mir Bescheid, wenn Sie, was noch brauchen.
January 1, 2011 at 1:26 am
This is my actual error message when I try to update dimensions and cube. The field is a wchar and if I configure the measure field like that and aggregation none I get this error message:
Fehler1Fehler im Metadaten-Manager. Der Datentyp des Stuecknr-Measures ist ungültig, da der Datentyp des Measures einem Zeichenfolgentyp entspricht. 00
That´s the german error message, in english it´s something like that:
Error in Metadata-manager. The measure datatype is invalid, because datatype of the measuer is a string.
What am I doing wrong?
January 3, 2011 at 5:55 am
Try compiling each dimension seperately to see if any produces an error. If so, fix that dimension first.
Let me know how that works. If ALL the dimensions for the cube compile, let me know and I'll see if I can figure out something else.
September 5, 2011 at 3:16 pm
I think I understand your problem. You are trying to create a string measure in a cube Measure Group so that you can then include it in your drill through. And I understand it you are not allowed to do this. The standard method (pls tell me if I'm wrong) of including details in your drill through is as follows.
(a) Build a Dimension with a Key that points to primary key in the fact data
(b) Add the descriptions and other detail as attributes to the dimension
(c) Change the AttributeHierarchyVisible property of each attribute to False. (This will ensure that users are not able to analyse the cube by these attributes)
(d) Connect this new dimension with the cube
(e) Consume these dimension attributes in the drill through action
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply