Offline
Hello Luo Yong,
this will not work with OLAP selection references because you only get elementnames and levelnames.
For data retrieval you need to create a connection with dependencies to your hierarchies.
After that you could realize your Onclick requirement with help of the REFERENCE formula.
In your example the trigger would be the Onclick Event of the clicked product (rice ,milk etc.)
CURRENTROW will return the rowindex of the clicked object. Now you could loop through the columns in your row.
[OBJResult] := REFERENCE ( [OBJYourTable] ; 2 ; CURRENTROW ( ) )
Continue with your conditions like "If the result is empty continue with the next column" etc..
Best regards,
Lars
7 Replies
Hello Luo Yong,
DRILLDOWN shows a popup menu with a predefined selection of documents.
With selection references of OLAP hierarchies you can display all selected elements or hierarchy levels or visible elements and levels only.
Best regards,
Lars Knebel
Thank you for your answer! Mabey I didn't describe my problem very well.My datas in database are as follows.On the hierarchies,there are food,rice,drink and so on.If i click on food i want to get the value 10,and rice 1001....
whether it is possible?
Mondrian schema:<Level column="code1" captionColumn="name"/>
<Level column="code2" captionColumn="name"/>
Hello Luo Yong,
this will not work with OLAP selection references because you only get elementnames and levelnames.
For data retrieval you need to create a connection with dependencies to your hierarchies.
After that you could realize your Onclick requirement with help of the REFERENCE formula.
In your example the trigger would be the Onclick Event of the clicked product (rice ,milk etc.)
CURRENTROW will return the rowindex of the clicked object. Now you could loop through the columns in your row.
[OBJResult] := REFERENCE ( [OBJYourTable] ; 2 ; CURRENTROW ( ) )
Continue with your conditions like "If the result is empty continue with the next column" etc..
Best regards,
Lars
thank you!
Would you like to comment?
You must be a member. Sign In if you are already a member.