TM1 Forum

Thanks for your answer Wimm, I will try your solution later on and will let you know if it works. Again, thanks a lot

So if I rewrite the query as NON EMPTY TM1SORT(TM1FILTERBYLEVEL(TM1SUBSETALL([Periods Dates]) , 0), ASC) * TM1FILTERBYLEVEL(TM1SUBSETALL([Regions]) , 0) * TM1FILTERBYLEVEL(TM1SUBSETALL([Cities]) , 0) ON ROWS FROM [Cube Sales] where [Dimension Measures].[Sales Flag] > 0 It say that it cannot create t...

Was wondering if someone can help me here. We just upgraded to the latest PA/PAW version (2.0.72) and our MDX view seems slower then ever. This is the MDX view statement: SELECT NON EMPTY {[Versions].[Actual], [Versions].[Budget]} * {[Dimension Measures].[xxxxx Flag], [Dimension Measures].[Total Hou...

Yes, forcing a dimension to 1 values is lot faster.

Does anyone have any idea about troubleshooting an MDX view?

Thanks

I was wondering if anyone is aware of a comprehensive PAW budget demo (on youtube or other sources). My goal is to present to FP&A team the full capacity on IBM Planning Analytics.

Thanks

Does someone has an idea how to start a TM1 Process or Chore from Azure Data Factory?

Thanks

(Admin note: Split and moved from an unrelated topic)

Does anyone knows how to fix the following: - PAW Ver 2.0.67 on Linux Issue I have a cronjob that start the nightly backup job (/paw/paw2067/scripts/backup.sh). Scripts is not able to restart PAW when it completes it execution. This is the error: Pulling couchdb (127.0.0.1:5000/planninganalytics/cou...

Well, I find the solution to my issue:ProportionSpreadToZeroCells was set to F in the tm1s.cfg file # https://www.ibm.com/support/pages/systemexception-spreadtotalzero-191-error-when-typing-value-consolidated-cell-caused-setting-proportionspreadtozerocells-be-false ProportionSpreadToZeroCells=T now ...

I was wondering if someone can help me with the PAW Forecast feature. I was trying to create my first forecast model following the example at: https://www.youtube.com/watch?v=c8fAftMecw4 However, every time I tried to create a forecast preview I get the same error (see attached screenshot) "Att...

Thanks so much for your help and advise.

I am trying to set DIMENSION_TYPE attribute to Geography but I do not have the }DimensionAttributes in my cube. Does anyone know how to find/enable such dimension? I am on IBM® Planning Analytics Workspace 2.0.62

Thanks

Thanks a lot "PavoGA" I was able to follow your suggestions and I created a view based on you MDX query SELECT [M].members ON COLUMNS, FILTER( [A].members * .members * [C].members * [D].members, [M].[Dispute Flag] > 0) ON ROWS FROM [cubename] The only odd think is that I was not able to cr...

This is the type of filter I am using: TM1SORT(FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([Product]) , 0) , [Product Cube].([Versions].[Actual],[Period Daily].CURRENTMEMBER,[Prod Types].CURRENTMEMBER,[Invoice Dates].CURRENTMEMBER,[Product Category].CURRENTMEMBER,[Product Cube Measures].[Open Invoice Flag]...

I would like some ideas/suggestion about solving the following issue: I have a cube with the following dimensions: A,B,C,D, M (Measure) The Measure M has fields called: Amount, Dispute Flag, Dispute Status I would like to create a Cube view that show only data when M. Dispute Flag > 0 Any help will ...

I was wondering if someone can help me solving the following issue: 1-I have a Active sheet in perspective; products are displayed on rows while Years are displayed on columns. 2018 2019 2020 2021 2022 Prod A $3 $2 $4 $2 $2 Prod B $2 $5 $2 $4 ....... Prod Z $13 $22 $34 $21 $2 2 - My goal is to write...