Autofilter for TM1Web?

kangbei

I searched for that topic, but didn't find anything usefull. Except that there is a function named TM1RPTROW.
The documentation was not explaning how to use the filter in detail (not enough for me).

I have a large web report and want to set a filter (like usual autofilter in excel) on every column with element names. When the report is shown, the drop down listbox should show every element name from the rows below. It would be great if there are no duplicates!  

If I select e.g. in one column element "china", the report should be updated, filtering everything different than china. Now the other listboxes should base again on the remaining rows, e.g. show in the article column all articels which are sold in china. And if I select "teddy bear" all rows not showing teddy bears should be disappear.

How could i handle this with mdx and TM1RPTROW? Where should I add this function???

ADMIN : Please try and post in the correct forum, ty

caoshuo594

In the TM1RPTROW function you can pass a MDX query which can apply filters on the query and your results will be displayed in the Active Form

hsszjw

I tried a lot, but nothing worked. Do you have an example (hardcoded?) for my example?
MyCube(Dim1 ... Dim5)

Filter everything which has not $A$1 in Dim3. (means show everything with $A$1 in Dim3)

I would try this:

{Filter( TM1FilterByLevel(TM1SubSetAll([Dim3]), 0) , [MyCube].([Dim3].[" & $A$1 &"])  <> 0)}

Where is my fault?

jsyyrs

The MDX statement which you have written does not seem to be right. Suppose if you want to filter on Dim3 then you will have to put Dim3 within TM1SubSetAll(). This will tell the MDX on which dimension you are working on. Later you apply Filter() in the MDX - when you apply the filter you skip Dim3 and use all other dimension in your syntax.

You syntax should look something like (following query will return all the elements in Dim3 which are non-zero in MyCube):

Code: Filter(
    TM1SubSetAll(&#91;Dim3&#93;)
    ,
    &#91;MyCube&#93;.(
         &#91;Dim1&#93;.&#91;Element&#93;
        , &#91;Dim2&#93;.&#91;Element&#93;
        , &#91;Dim4&#93;.&#91;Element&#93;
        , &#91;Dim5&#93;.&#91;Element&#93;
        )
        <> 0
)