I want to pass value to parameter in my defined store procedure. My value is come from tree prompt. DataItem of tree prompt is "rootMembers([Business view].[DimMy].[My])". Parameter name of tree prompt is 'pmt_My'.I want to get value of specified node to pass into my store procedure. When I defined macro function in Framework Manager, which is #prompt('pmt_My')#, my tree on my report can not show its tree, only show top node (before I did macro function, it can show its tree). How can I resolve this issue? I'm working on Cognos 8.3
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Issue when use macro function #prompt# with tree prompt
- Thread starter khoinh
- Start date
Similar threads
- Locked
- Question
- Locked
- Question