TM1 Forum

- The report has virtual hierarchies => Exploration view and quick report can do - The rows must be dynamic => Dynamique view and Exploration view can do - There could be some element attributes as well on the rows => Dynamique view and Exploration view can do - Some dimensions in the context must b...

Hi, I want to insert the value of measure "Current_YEAR" of cube "FG_PARAM" to MDX to make the MDX change with my selector. Can some one give me 1 exemple? for exemple : if i have 2021 in cube "FG_PARAM", the MDX take the value 2021 question MDX.png Any help will be app...

your post give me a good idea and maybe i can try this in the future. the solution is you can save your selected subnm in TM1 and make a process that write this selected in the new page. In the new page, dont use the subnm but use DBRW to get your saved selected and make a process that write a selec...

hi, you can do it in PAW with Drill Through function The example is taken from TM1 Official Guide I put Cursor in the cell of Travel row (Cube1) 01.JPG Click the Button Go To Details List appears (Cube 2 Appears with the same dimensions + 1 dimension of rows). And it shows the same Travel element in...

Another way might be to use the Bedrock library, where most of the code has been built for you. Specifically, the }bedrock.cube.data.copy process. thanks, it is the thing i need for now !!! That's the easy bit - because the cube name is just a string: CubeName ='XXX'; cellputn(cubename, v1,v2....vn...

Hi community, Iam looking for an idea. :!: I have a client who have 53 cubes that use the dimension Version I have to dev something that copie a version to another version for all the cubes. Right now, the only solution i have is make 53 processus copy for each cube and 1 process MASTER to execute t...

Exactly, it's well understood already that the consolidation in the alternate hierarchy doesn't exist in the base hierarchy, so the question is, "what do you want to do for the base hierarchy/dim?". Your drill-through view is going to need some element/subset selection for the base hierar...

What element in the base hierarchy do you want the consolidation from the alternate hierarchy to map to? If the alternate hierarchy consolidation doesn't exist in the base dim, you'll need to specify something, otherwise it will use a default which you're seeing with the "ND" selection. h...

hi Ascheevel, i dont really understand the idea. can you give a an exemple for this? :oops: Thanks ! It's been a while since I did this with alternate hierarchies, but you can parse the hierarchy selection, build the view manually in the prolog, and return that instead of the wizard-defined view. To...

Are you sure that drillthroughs are supported in alternate hierarchies ? this is the first time i use a alternative hierarchies, so, i dont know :mrgreen: It's been a while since I did this with alternate hierarchies, but you can parse the hierarchy selection, build the view manually in the prolog,...

Hi, Iam trying to use new function Virtual Hierarchy on PAW I have some virtual hierarchy with the element consolided diffirent. I need to make a drillthrough but i realize that i can not drillthough on an element consolided of virtual hierarchy because this element consolided is not exist in archit...

Thank maren for the reponse, we can close the topic here. To answer your question : - Bit puzzled why the REF_BENCHMARK ATTRS for D_PRICING_GROUPE_PRIX_RELATION would be asking if it was equal to itself? ==> because i have to apply this rule only for the element who have himself in the attribut REF_...

Thank for the explain! i have it something in excel formula but this is a first time i have in TM1, i have no idea why a condition can make a reference circular while it work on 1 but not other probleme is on this line, but this line dont make the trouble in the first case (PR1 MAX) rule line error....

Thank maren for the reponse, problem solved, i found that i compare A with B while B is calculed by A. but i still dont understand why it cause reference circular error. B = A * coefficient (0,1-1) i have a condition if (B>A), B, A. I still need to do this and i need to understand why there are a re...

To be honest, in beginning, my question is only "what is a circular reference rules"
In the forum rule, i saw that i need to be as clear as possible. this is why i try to post all code here.
But this is maybe not a good way to ask a question. Iam sorry about that.

hi,

today, i got this error that i never seen that before, so, any help or any exp will be appreciated !

thanks !

my trouble

Under capabilities, Is anything set against Consolidation Typein spreading? Personally, I sleep better at night if this is set to deny :) Thank Maren, i have the same opinion as you, the reason that i allow the user to type in C element is : they are typing in a cube Reporting that have only static...

Looks like you are trying to do a spread, i.e. data entry at the C level. Judging from the error message the user doesn't have write access at the C level intersections in the view. So I'd say recheck the security model but make sure you consider that they need WRITE access at the C level to do so....

hi, my client have this trouble when i try to enter a value in this cell (this is a consolidated cell) tm1 right question.png right now, the only thing that i can do is give him a admin right, if not, he can not write in this cell. i need to solve this probleme as soon as possible. and i have no ide...

i think MDX option is still a better way because it is more flexible ! and i can add a variable instead of a element fixe!! Hi Keith, Edited: I get what you mean, you just select from one dimension but from different blocks of the other dimension. Well, I never knew that worked. I should thank Mr Du...