TM1 Forum

Hi everyone, Looking for a bit of advice on this topic. We currently have a PAfE report that auto-logs in users as soon as they launch the report. This is working as expected for our on-prem version of PA. While preparing for a cloud migration I switched the connection string to point to our cloud U...

Hi William, I'm experiencing the same issue as the op and your code does work but I have a small wrinkle. If I need to keep excel in maual calc mode after a user makes a selection from a SUBNM is there any vba code you can think of that would do this? The reason we'd like to keep excel in manual cal...

Thanks Paul for your response. The behaviour I am seeing is that when I create a hierarchy from the string attribute called Sales Rep I get the hierarchy below: Bob Jane Sue Bob; Sue John Jane; Bob Jane; John The parent node Bob now has only one order # attached to it (Order #001). If I wanted to us...

Hello all, Just looking for some guidance to clear up what is possible with virtual hierarchies in PAW. I have created a hierarchy on my orders dimension called Sales Rep. Each sales rep is assigned to an order number but in many cases there are more than one sales rep assigned to an order number. W...

That did the trick thank you!

Hi all, Just need some assistance in writing an MDX statement to pull in a cube value and pass it in to the function TM1SubsetToSet. Here are some details: -Dimension name is Location -Lookup cube name is User Settings -Measure trying to retrieve subset name from is Location_Subset_Name I can get th...

Thank you Wim.
Appreciate the feedback. Will give that a try.
Cheers!

Hi all, I'd like to see if there is a way to re-point the path of a PAW action button after creating a snapshot and deploying. Here are some details: -I've created a snapshot using existing PAW assets -Some of these assets contain PAW action buttons with links to other PAW books -When I proceed with...

Thank you both for the feedback!
I've used both suggestions to come up with a solution that works well.
Much appreciated!

Hi all, Just looking for some advice on the best way to write a TI that is calculating historical averages based on a range of periods, then inserting that calculated value to a specified future month. Here are some more details: I have 2 parameters in my TI process ( pAvgYrStart and pAvgYrEnd). The...

Hi Wim,
I can use either.
Right now the report is authored in Perspectives but will be converted to PAfE soon enough.

Hi all, Just looking to confirm if the following situation is possible. I don't believe it is, but would like to confirm and maybe get some thoughts on what is possible. I have a dynamic report created from a 3 dimensional cube: Order # Line Measures In the rows I have Order #, Line, and several mea...

Hi everyone, Wondering if there is a way to make a websheet in PAW render the same regardless of what type of device it is being viewed on? When a user views a particular book from a laptop it renders with vertical/horizontal scroll bars as compared to when viewing on a larger desktop monitor. I’m w...

Hi all, Just looking for some thoughts on converting perspectives reports to the Pafe version. Here are some details: Some of the perspectives reports contain quite a bit of VBA. The VBA does things like snaps out the entire book to a static excel sheet, converts the entire report to PDF, sets date ...

Thank you Declan. That works well. One small wrinkle though if the lookup cell value is bob (lower case) instead of Bob this doesn't work. I'd have to account for users typing in either I imagine. I found this which actually works very well in PAW but not in PAX. {FILTER([Line].MEMBERS,Instr(1,[Sale...

Hi all, Just looking for a bit of advice compiling an MDX statement. Here are some details: I have a 2 dimensional cube called Sales which contains a Line dim and Measures. I want to apply filters to the line dim based on values in the cube. I'm able to apply filters properly when the value typed in...

Hi all, Just looking for a bit of advice to see if there is an easy way to solve this before I go down a path that will cause a lot of time/effort to be spent on developing something. Here are some details of what I'm trying to do: I have a cube that I'd like to export to a SQL DB. The cube has 80+ ...

Thanks guys for your replies.
I followed the example from this post below.
viewtopic.php?t=9490

In any case with or without the Expand function It's working which is what I care about.
Thanks again.
Cheers!

I got this sorted. Rather than delete the post I'll paste what I did here in case it's useful for anyone else. After searching through the posts on here I initially tried the expand Function in my statement but didn't work without realizing I needed to declare a variable for the Expand function to w...

Hi all, Looking for a bit of advice on an ODBC Output to a SQL table. Here are the details: I have a column in the the table called [Date] format is Date, Null There are dummy records in this date field which are populated with 1900-01-01. I would like to convert all of those dates to a NULL. When I...