on 02-04-2015 6:52 PM
Hi,
I've am facing this issue quite a while.
One of the dimension has a hierarchy node, that i'm using to pass through open doc parameter via design studio to Analysis for OLAP.
I'm able to pass the text, date and other prompts value, but the "hierarchy node" comes with "+" which is not carried while passing the dimension through open doc.
For example: On Design studio Side : Dimension - "+costobjectsmaterial".
OLAP : received:- " costobjectmaterial" (missing the +).
Tried to correct on Bex: variable name as "Text", "Key" all possibility. Still the issue is not resolved.
Code- DS_1.getVariableValueExt("dimension")
Is there, some additional code to pass "+".
Highly appreciate your response, thanks
convert.urlEncode(Text) should help you pass the plus.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michael,
Thanks for your response.
I just tried with %2B.
I was able to pass +(%2B), now the issue is my olap dimension looks like this.
OLAP end:- "+ costmaterial"
Now i have space between PLUS and Dimension.
So, i went back in Bex and change it to "TEXT" instead of "Key:Text". This solves my space problem and i get ("+costmaterial").
But seems like OLAP is set for "Key: Text" by default, my bex changes DO NOT apply.
I guess the reason it is throwing me space is because OLAP is set for Key and Text, but on Design Studio side "+" gets dropped in open doc and leaves a space there.
Now, by making it memorize the + by applying you trick, it does not replace the blank but adds it before that.
I removed all the spaces in my code but no luck, thanks
Hi Victor, Hi Michael,
Victor - I tried your code.
I was able to get the ("+costmaterial"), which i was looking for.
Now, filter applied on Design Studio are exactly same as passed via open doc. to AOLAP.
I should be able to see the same results on both applications but that's not what i see.
So, i check the prompts on AOLAP, looks good to me, i could see (+costmaterial).
Now, when i click ok button, it refresh the application and comes back with right data. I can still see my passed dimension as (+costmaterial).
Looks like OK button is acting as trigger and ultimately feeding it the right text format.
Michael - using your idea gives me the same result as what i get with Victors one.
Thanks both for your time.
I'll play with it little more and see if converting it to string helps, thanks
-Fahad
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.