Hi All,
I am unable to retrieve data using DBRW in perspectives, I am using subset in my DBRW formula. It works fine in all the versions except for one version.
Formula works fine when i use individual element from company dimension where as it is not working for subset with multiple CC's from the dimension.
Unable to retrieve data using DBRW
-
- MVP
- Posts: 3113
- 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: Unable to retrieve data using DBRW
This behavior is undocumented so you are on your own.
Is the subset a private one ? Is there a conflict with a private subset ? Consolidated rules in the cube in that specific intersection ?
Is the subset a private one ? Is there a conflict with a private subset ? Consolidated rules in the cube in that specific intersection ?
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
-
- Posts: 19
- Joined: Mon Jul 09, 2018 12:45 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: MS Excel 2010
Re: Unable to retrieve data using DBRW
Hi Wim,
Thanks for your reply, It is a public subset and there are no consolidated rules in cube for that specific intersection. When i use only one company code in DBRW i am able to retrieve data. when i use subset which is combination of 5 company codes it displays value 0. This is behavior is observed in only one version. In other versions DBRW works fine with same subset. Let me know using SUBNM in DBRW with subset has any impact?
Thanks for your reply, It is a public subset and there are no consolidated rules in cube for that specific intersection. When i use only one company code in DBRW i am able to retrieve data. when i use subset which is combination of 5 company codes it displays value 0. This is behavior is observed in only one version. In other versions DBRW works fine with same subset. Let me know using SUBNM in DBRW with subset has any impact?
-
- MVP
- Posts: 3113
- 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: Unable to retrieve data using DBRW
Impact ? It is just not supported as functionality, so you should create a consolidation with the required children. If needed, use a small TI process to update (this part of) the dimension. Other than this, certainly in a production environment, do not rely on this ‘behavior’.
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
-
- Posts: 19
- Joined: Mon Jul 09, 2018 12:45 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: MS Excel 2010
Re: Unable to retrieve data using DBRW
Issue was with Subset name. Subset name was similar to one of the element in dimension due to which it didn't fetch data for rest of the elements. After changing subset name issue got resolved
-
- MVP
- Posts: 3113
- 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: Unable to retrieve data using DBRW
Good that it’s solved. Still I would refrain from using this kind of ‘functionality’, but if you want to use it, you can do so
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
-
- MVP
- Posts: 3652
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Unable to retrieve data using DBRW
By “similar to” I’m guessing you mean “same as”
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 3113
- 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: Unable to retrieve data using DBRW
Not the same as. There was different spacing and different case
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
-
- Posts: 19
- Joined: Mon Jul 09, 2018 12:45 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: MS Excel 2010
Re: Unable to retrieve data using DBRW
@Lotsa,
You are right, 'Similar to' means 'same as' . Issue was with one of the element in Subset and its name being same. DBRW formula was fetching data only for element with subset name.
You are right, 'Similar to' means 'same as' . Issue was with one of the element in Subset and its name being same. DBRW formula was fetching data only for element with subset name.