hi,
my client need to make some calcul with a subset, not a element.
when i look in documentation, i find that DBRW only reference with element.
there are a way to do what my client want? for exemple : DBRW(TM1ServerName:CubeName, subset1, Element2, Element3, …, ElementN);
thank a lot for help!
documentation
DBRW(TM1ServerName:CubeName, Element1, Element2, Element3, …, ElementN);
TM1ServerName = Name of the TM1 Server
CubeName = Name of the Cube
Element1 to ElementN = An element in each dimension from the Cube. Each element must be ordered based on the dimension for the Cube.
Cross-posted IBM community :
https://community.ibm.com/community/use ... 4eda43146b
DBRW with a subset
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
DBRW with a subset
Last edited by mrdauduong on Mon Oct 10, 2022 7:49 am, edited 1 time in total.
-
- Regular Participant
- Posts: 197
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: DBRW with a subset
Have you tried it? you can replace an element name with a subset name within the dbrw. If it's not working check the view() or tm1rptview() is fine.
-
- Regular Participant
- Posts: 350
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: DBRW with a subset
Hi,
As per the following link, I thought PAX didn't allow for subsets within DBRW's:
https://www.tm1forum.com/viewtopic.php?t=14731
It is a fairly old thread so maybe something changed since then that I wasn't aware of and Burnstripe is aware of.
If that is the case, what did I miss Burnstripe?
Maren
As per the following link, I thought PAX didn't allow for subsets within DBRW's:
https://www.tm1forum.com/viewtopic.php?t=14731
It is a fairly old thread so maybe something changed since then that I wasn't aware of and Burnstripe is aware of.
If that is the case, what did I miss Burnstripe?
Maren
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: DBRW with a subset
User-defined calculations may be an alternative.