Hello All,
I am currently working on the attached websheet in Perspectives. The cube view it is referencing is also attached.
In the websheet, rows 13-16 are all context filters in the view, and can be changed in the sheet and still provide data after being recalculated. Rows 11 and 12 are not filters in the view, and are set up as SUBNM functions in the sheet, with row 23 referencing the values in the SUBNM cells. Whenever I select something other than the two versions in the view (Actual and Budget), the numbers show immediately after selecting it, but disappear after recalculating the sheet. Since this is intended to be a websheet, this will just always provide me with zeros when selecting a new version.
Is this due to the other versions not being in the cube view? If so, has anyone else faced this, and how have you addressed it? Is there something else here I am missing? Also, for reference, columns G-L correspond to the view, while D-F are DBRW functions.
Thanks in advance.
Perspectives - Values Disappearing After Recalc
-
- Posts: 4
- Joined: Mon Jun 05, 2017 3:40 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Perspectives - Values Disappearing After Recalc
- Attachments
-
- CubeView.PNG (8.13 KiB) Viewed 4385 times
-
- AfterRecalc.PNG (37.03 KiB) Viewed 4385 times
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Perspectives - Values Disappearing After Recalc
Have you added any additional calculations? For example you may have added Excel calcs that derive an element used in the DB statements. If you have it may be down to calculation order. Try changing a DBRW in to a DBR. If it's not this you'll to provide more information regarding the sheet. It doesn't look like a straight slice.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Perspectives - Values Disappearing After Recalc
Seeing that the SUBNM starts on row 11 I am guessing that this is not a slice but an Active Form.
In which case ...
In which case ...
Yes it is. For cells belonging to another slice you can't use the TM1RptView reference as the cube reference in the DBRW. You need to use another VIEW reference (or hardcoded server:cube string but this could have performance drawback vs. proper View formula). But for the active form to still work you must have at least one column referring to the TM1RptView.DavidS wrote:Is this due to the other versions not being in the cube view?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Perspectives - Values Disappearing After Recalc
Is this an active form or just a slice? You have a version in C11 and a version in C12 so if it's an active form which version is referenced in the TM1RPTVIEW formula? Is there just one TMRPTVIEW formula and you are pointing both the Actual and the Budget DBRWs to that same VIEW? That's not going to work. You need to put the version dimension on the columns instead of a title dimension if that's the case.
-
- Posts: 16
- Joined: Thu May 12, 2016 10:29 am
- OLAP Product: TM1
- Version: PA 2.0
- Excel Version: Office 365
- Location: Frankfurt am Main, Germany
Re: Perspectives - Values Disappearing After Recalc
lotsaram, how to understand whether cells belong to another slice? I have an ActiveForm to analyse and it is not straightforward to say whether cells come from the same slice or not.
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Perspectives - Values Disappearing After Recalc
Hi
Does the first argument of the DBRW formula refer to the server name and the TM1RPTVIEW function or not ? Usually if it’s not it refers to a different slice and it will be as Lotsaram pointed out.
Does the first argument of the DBRW formula refer to the server name and the TM1RPTVIEW function or not ? Usually if it’s not it refers to a different slice and it will be as Lotsaram pointed out.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly