TM1 Forum

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.

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 ?

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?

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’.

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

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

Arb1486 wrote: ↑Wed Dec 26, 2018 3:52 pm 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

By “similar to” I’m guessing you mean “same as”

lotsaram wrote: ↑Wed Dec 26, 2018 5:45 pmBy “similar to” I’m guessing you mean “same as”

Not the same as. There was different spacing and different case

@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.