Forum Discussion

PowerBWhy's avatar
PowerBWhy
Frequent Visitor
6 years ago

SAP BW BEx Value is not a cube

This technique was taught to me by someone I unfortunately no longer have access to. I can't get it to function properly and haven't found any answers searching around.   I am importing data throug...
Need Help
Stachu's avatar
Stachu
Community Champion
6 years ago

If I understand you correctly right now you have a list named List that has one element, which is List of strings. If that's the case then List{0} will indeed return a list. So I don't think it's the syntax issue, both the codes are equivalent.

 

I think the problem is here:

I think that V000011 stands for December (or 12th period in your fiscal year assuming the index starts at 0) and for that period valid cube entries range from week 48 to 52, so your list ranging from 29 to 47 is not valid here

For earlier weeks you would need to use (I am guessing here) V000010, V000009 , etc. The easiest way to check it is to filter the cube manually for different month and see what M code gets generated

PowerBWhy's avatar
PowerBWhy
Frequent Visitor
6 years ago

Yes that is correct I have a list of strings within "List" and thus I was using {0}. I tested your theory by  bringing in weeks across multiple months and years and still received the same "[!V000011]". I'm assumong this just designates the week variable. Here it is below.

 {Cube.ApplyParameter, "[!V000011]", {{"[ZFISCWK3].[201816]", "[ZFISCWK3].[201817]", "[ZFISCWK3].[201818]", "[ZFISCWK3].[201819]", "[ZFISCWK3].[201939]", "[ZFISCWK3].[201940]", "[ZFISCWK3].[201941]", "[ZFISCWK3].[201942]", "[ZFISCWK3].[201943]", "[ZFISCWK3].[201944]", "[ZFISCWK3].[201945]", "[ZFISCWK3].[201946]", "[ZFISCWK3].[201947]", "[ZFISCWK3].[201948]", "[ZFISCWK3].[201949]", "[ZFISCWK3].[201950]", "[ZFISCWK3].[201951]", "[ZFISCWK3].[201952]"}}}

I also tried matching the weeks that I initially selected with the weeks that I filter for in my query and still received the error. Thanks for all your help on this.