Hi,
When using dynamic subset by two dimension it works perfectly in TM1 Achitect, but it is not working in TM1 Application (Insight). Is this known error ? This was working in previous version 9.5.2 and TM1 contributor.
Example:{FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [HFM_SKU] )}, 0)}, [HFM_SKU].[Entity] = [BS_Entity].[EntityCode] )}
Tnx
TM1 10.1 dynamic subset by two dimensions
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1 10.1 dynamic subset by two dimensions
If resetting a row or column dynamic subset based on title element selection works in architect, TM1 Web and Contributor but doesn't work in Cognos Insight then you may have a case to report a bug as the overall design philosophy behind TM1 has always been to have consistent behavior between UIs.
-
- Posts: 29
- Joined: Thu May 26, 2011 5:38 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2008
Re: TM1 10.1 dynamic subset by two dimensions
Is it possible to set portal to use TM1 contributor 9.5.2? And how?
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: TM1 10.1 dynamic subset by two dimensions
When you say "set Portal" what exactly do you mean? You want TM1 10.1 to use contributor 9.5.2? That's likely not going to be possible as the security architecture for contributor is vastly different between 9.5 versions and 10.1.
Re: TM1 10.1 dynamic subset by two dimensions
I think I have the same issue. I have a cube view based on a dynamic subset and a TM1 application (approval type) based on that view. If I open the approval node using TM1 application web (contributor) the dynamic subset works fine. However if I choose to open it using Cognos Insight (connected or distributed), the view shows no data as the dynamic subset does not work
I have installed TM1 10.1 FP1 and the problem stays.
Are the TM1 Application Web and Cognos Insight client supposed to have different behavior?
Regards
Andre
I have installed TM1 10.1 FP1 and the problem stays.
Are the TM1 Application Web and Cognos Insight client supposed to have different behavior?
Regards
Andre