TM1 Forum

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

I should have added emojis to my post as we all know that you are not the biggest fan of PAW 😂 It was meant to be funny 😆 and certainly not as viable option beyond any work done for fun or demo purposes. But anyway, for completeness, custom snippets can be created. https://www.ibm.com/docs/en/planni...

Yes, it's been 3 years. Time flies and IBM is coming to rescue:
PAW with your own custom snippets (https://www.ibm.com/docs/en/planning-an ... ess-editor)

Thanks for the detailed descriptions. I have never used Google BQ but it appears that a flat file can be loaded: https://stackoverflow.com/questions/52119663/loading-a-csv-into-bigquery-using-bq Wouldn't that be quicker and safer ? At least I do a BULK INSERT into SQL tables (Epilog of a TI process)...

WilliamSmith wrote: ↑Wed Sep 06, 2023 3:43 pm Anyway... while we're here in 2023... using ChatGPT to help generate, as well as breakdown and understand MDX statements is invaluable. It also knows Turbo Integrator and rule/feeder syntax!

Like the CubeNext function in TI

Good, elegant, solution.

Minor remark, you have the $url = part twice.

What happens to the security assignments for the process, when you delete and recreate ?
In general, I try to update rather than recreate, to not lose other settings.
Another example, data against the process in the }Processes dimension in a cube: is it lost or not, when deleting and recreating ?

monkey97 wrote: ↑Tue Aug 29, 2023 9:44 am They are defined in Cognos, but we haven't got "groups_unwrapped" table in our database... and similar neither.

Isn't it something that Yuri scripted in the SQL ?