DBRW with a subset

Post Reply
mrdauduong
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

Post by mrdauduong »

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
Last edited by mrdauduong on Mon Oct 10, 2022 7:49 am, edited 1 time in total.
burnstripe
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

Post by burnstripe »

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.
MarenC
Regular Participant
Posts: 346
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

Post by MarenC »

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
User avatar
gtonkin
MVP
Posts: 1192
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

Post by gtonkin »

User-defined calculations may be an alternative.
Post Reply