TM1 Forum

Public or enterprise Github? I ran into similar errors trying to connect on-prem PAW to an enterprise Github repo and so far haven't got it working. I suspected that the connection was being blocked/rejected by enterprise github admins but haven't confirmed that. You are using the SSH url and not th...

How big is the view in your ViewConstruct? You should be able to construct a small view to trigger the cube load back into memory. Also, when a cube is reloaded to memory, feeders are reprocessed which takes time & memory. The server theoretically should be reusing the garbage memory from the pr...

Formatting your code will go a long way in helping you to read/understand it and posting within a code block will go a long way in helping the rest of us help you. By the CellGetN you posted at the bottom for InvStatus, it appears you're using only the variables defined in the source view to derive ...

Have you considered loading the data as is from source and using formatting in TM1 to display millions as thousands?

Thousands: #,##0,;(#,##0,)
Millions: #,##0,,;(#,##0,,)

True, but you can create the cube with below line in a TI.

The control cube }ApplicationSecurity is accessible in both PAX and PAW.

I can't find a working download link, but Quebit had a free tool called "Print Reports" that mimicked the old functionality. They also have their ReportWorq tool with a whole host of other features available by subscription.

*I am not affiliated with Quebit

PAW users and TM1 server users are separate entities. You succeeded in adding the user to PAW but have not added the user to a TM1 server yet. If you're mode 5 with CAM, the user will add automatically to the }Clients dim when they log on to a server. Alternatively, you can manually add them to the ...

There was recently a thread on this and it's come up other times as well that you can find with a bit of searching. File semaphores is probably the safest, but I sometimes use a monitoring cube with "called" and "completed" columns where the calling process updates the called col...

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=pctf-runprocess-1 https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=functions-getjobstatus Might not be obvious to some folks, but the functions/features Dan is referring to are only available currently in V12 or Planning Analytics...

TM1py has search_for_rule_substring and search_for_string_in_code

You're conflating two separate things. The MaximumViewSize parameter is literally just the memory required to to hold the values in the view. To get to those values though, the server might need to evaluate/process rules on any number of cells behind the scenes which consumes memory but is not inclu...

WilliamSmith wrote: ↑Wed Mar 15, 2023 7:14 pm Doesn't Bedrock require Cubewise ARC for TM1 paid software?

Absolutely not and for a few good reasons: Bedrock predating Arc and Cubewises's committment to Bedrock being an open source collaboration like TM1py.

Oof, I indeed missed handling for when date is in prior year's ISO week count. Good catch, +1 for using NewDateFormatter, and thank you for posting updated code. A couple thoughts: As much as I like a Dez variable for Deutsch Dezember, I don't think these variables are necessary and can be removed. ...

I'm guessing you're just changing dimension selections/subsets in the view and not trying to render a completely different cubeview right? You could use a parameters cube to store the mdx parameters and have the cube mdx reference that cube for dimensions selections within the query.

But most of all, are you sure you want that much overfeeding (most probably) ? To expand on Wims insightful question, why are you populating the Rate measure verbatim in the Labor cube anyway? I'm guessing you're using those rates to calculate dollars based on some other census measure like hours. ...

['Business Rate'] => DB( 'Labor','All Projects','ALL HR Employees',!Months,'Bid','PLC Rate' ) , DB( 'Labor','All Projects','ALL HR Employees',!Months,'Planning','PLC Rate' ) ; You could also create a consolidation with both Bid and Planning elements as children and then feed just that consolidation...

DBRW and DBR are treated the same in PAfE That's interesting... I use a mix of DBR and DBRW when I need to ensure that (eg) picklists are populated (DBR) before data is retrieved/updated (DBRW). The last time I did this was with PAFe and the behaviour (which I needed) was as in the days of yore (Pe...

I don't see any immediate issues in your code and was able to execute it successfully on my end using the setup your described. There are a number of easier ways to achieve what you're trying to accomplish, the main one being bedrock . There is already a bedrock process for creating a hierarchy base...

If you must do this in perspectives, you could put a rule on your Value measure that forces the value to zero when the flag value is "inactive" and then set zero suppression to 1 in your TM1RptView formula. If you still want the Flag measure visible, you can populate that by referencing th...