Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
sort crossstab by custom key
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I am trying to sort a crosstab. In the sort key, I have used the following condition.</p>
<pre class="_prettyXprint">
if (params["Category"].value == "QOL")
{
data["Current_Cat1/Part1 YTD::Category"]
}
else
{
dimension["Cat1"]["Part1 YTD::Category"]["Part1 YTD::sort"]
}</pre>
<p>
The sort on first condition is not working. I have verified that the params["Category"] is indeed "QOL" and the first condition is met but still the sort is not working</p>
<p> </p>
<p>If I simply use</p>
<pre class="_prettyXprint">
data["Current_Cat1/Part1 YTD::Category"]</pre>
<p>then the sort works but If I put this inside the condition, then the sort does not work even if the condition is met</p>
<p> </p>
<p>One more thing. If I check the dropdown list, I can see data["Current_Cat1/Part1 YTD::Category"] but if I open the javascript expression, I do not see this measure. I can only see the groups and dimensions inside cube but not the measures</p>
<p> </p>
<p>Regards</p>
<p>Arif</p>
<p> </p>
<p> </p>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet