TM1 Forum

What is unfortunate, is that subsets for the picklists all have to exist. It is not possible to inject an MDX for a subset (combining several inputs in a string for the MDX) and have the server execute it at run-time. That would be much neater. You can work around with a button and a simple TI proce...

Hi all, I thought this TI process might be useful to others as well. I have been writing this over the past couple of days, so if anyone wants to further test it, much appreciated ! The idea is that users in a TM1 model can have private objects: - subsets (*.sub files) - classic views (*.vue files) ...

I clearly need some help, so if someone can share a powershell script that does something similar, i would really appreciate it Hello, I do hope that someone can post code here. Until then, I would advise to start yourself because if no one does, you still have nothing. Build it gradually, hardcode...

Can you provide some details about your Powershell Script you use to hot promote TI Processes? I am trying to do the same thing but I cant find any help online Where are you in your TM1 REST api journey ? Do you use a tool like Postman to execute requests and capture the response ? Do you use Pytho...

I understand all of that, but it’s a repetition of what you wrote. If you want to narrow down the problem you will need to comment out code and see it in more detail using asciioutput or similar. On both machines. Then compare and narrow down even further if needed.

What are you loading those data to ? Regular cube cells ? Cells in attribute cubes ?

Did you try limiting the TI processes to only an AsciiOutput ?
Is connecting to the source taking a long time or processing the data/metadata tabs ?

AFAIK, indeed you need the elements and the edges.
No direct endpoint to do this although that would be useful.

Good information Declan. In the first code snippet, I would calculate the variance based on the 2 variables above. Less hardcoded elements, shorter code too. WITH MEMBER [Period].[Period].[Latest Period] AS StrToMember ( "[Period].[Period].[" + [System Variables].([System Variables Lines]....

What you are looking for is something IBM has talked about doing for a long time, but I don't see it on the roadmap. https://bigblue.aha.io/published/30f7b700d5eb7d18cfdd19c793f4a10d?page=4 Basically it would be an extension of synchronisation where the target set MDX is dynamically driven by the s...

Hi, I found one use case as follows FILTER( [ DimensionName ].MEMBERS , [ DimensionName ].CURRENTMEMBER.PROPERTIES(" AttributeName ") = IIF([}ElementAttributes_ DimensionName ].[ AttributeName ].PROPERTIES("Element_Type") = "2" , " SearchTerm1 " , " Sear...

lav4you wrote: ↑Wed Oct 18, 2023 6:54 pm

PavoGa wrote: ↑Tue Oct 03, 2023 1:42 pm Got a question. Can we use "ELEMENT_TYPE" to filter for Aliases?

Can you expand on how would you like to filter?

Probably, which attributes are aliases, which are string attributes, which are numeric.
Something like the DType or ElementType functions.

Same question in the IBM PA community: https://community.ibm.com/community/user/businessanalytics/discussion/paw-git-repository-integration-issues?ReturnUrl=%2fcommunity%2fuser%2fbusinessanalytics%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d8fde0600-e22b-4178-acf5-bf4eda43146b#bm4...

Won’t work

Good question. After 30 min trying a few things I could not come up with a solution using MDX for subsets.

Thanks for providing the resolution.
I have never put that directory inside the TM1 data directory.
Just like the TM1 logging directory, never located inside the TM1 data directory.

OK, that may be a long term solution. My question was, if I missed a detail or if I should use the function differently, because I never think, that I was the first one, who discovered an issue. :D If it is not a bug, but it is a feature, I can live with that. Thanks Wim! I would advise you to look...

When you think that you stumbled upon an issue, you can create a new issue in the Bedrock repository in GitHub.

Hi Chris, It's been a while since I used code like that, probably the 10 years that have elapsed since my article. PAfE buttons are a different beast too. That being said, the article says what to do without these references (but you lose intellisense and so on). The references were visible (at leas...

For those of you who want to see a bit more coding on the 3 options, here is a preliminary version with more coding: DatasourceASCIIQuoteCharacter = ''; sDate = '2023-09-11'; ######################################################## # OPTION 1: the FormatDate function ################################...

When we want to enable the use of Microsoft Excel serial dates instead of Planning Analytics serial dates, we would use UseExcelSerialDate=T in the TM1s.cfg file: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=pitf-useexcelserialdate However, this has implications, for instance on determ...