Nathan, Hello again and thanks for reaching out. Unfortunately this subject area does not have a time dimension, let alone a time presentation hierarchy. Dimension "Account Established Date", (at the bottom of the subject area panel displayed on the screenshot) is the closest to a time dimension. Is there anyway to come up…

Hello Dimple, Thank you for the detail explanation. Will look to the alternative syntax for more references. Stay healthy and safe.

Hello Dimple, Apologize for my delayed response. No, with regards to the followup question posted on 31-Mar. Now I want to find out if there is a way to set the selected columns so they are in sync with filter-prompt results, without having to write formulas involving the "by" command. For example, to create a column that…

Hello Dimple Nagesh, Works perfect. Further question, is there a way to set the columns (or write a formula) so they are dynamic to the filter month apart from using (FUNCTION...by...) operation? For example, the "Rank (By Brand)" column will automatically reflect the subject ranking per the Year-Month selected in the…

1) Permission route is off for now. 2) Don't have access to modify the database nor repository. 3) Attached screenshot shows the interface that I am getting data from. How may I find out "how" I am consuming the data? Thank you.

What is implicit aggregation / binning? Max 99 rows would be fine because there are less than 50 records. The purpose behind this extraction is to single out the unit-per-case-pack-quantity info. within an item no. Thereby the info. can be used to multiply with case pack quantity to determine the total number of units per…

Hello Christian, Thanks for reaching out again. The beginning position is always the 5th starting from the left, at the same time the needed numbers can be single or double digits. For example: ABCD11HIJ150150 --> 11 ABCD12EFG152151 --> 12 ABCD3EFG7230101 --> 3 ABCD4HIJ2040100 --> 4 Best.

Hello Fernando, Thanks for reaching out. Unfortunately my account is not enabled with EVALUATE support per below error message. Thereby would you have alternative suggestions that do not involve EVALUATE functions? [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to…

Thank you again Nathan for the explanation and 2 methods, which both works. Good day.

Noted a presentation hierarchy is required in order to utilize the TODATE() function. Thanks for introducing the metadata repository database (RPD) term "presentation column" and posting a link for reference on time series functions. By drawing on an hypothetical scenario with a screenshot, you've made it easy for me to…

Hello again Nathan Mogan, Thanks for putting the time to make an example, and understanding the example was made a lot easier with the screenshot. I will attempt to replicate this approach for my scenario. Thank you. Jon

Hello Arun, Thanks for reaching out. 1) I typed in "year". 2) There is no "time hierarchy.Year" in the subject area (SA). 3) In the SA, in "Time" folder, there is a "Year" dimension component (per enclosed screenshot). However entering it into the TODATE() function produces the following error: Formula syntax is invalid:…

No problem. Turns out the prompt is right-click friendly, and doing so open a "Sort" option. Thank you very much.

Where in the prompt will I be able to access LSQL editor panel?

I do not have access to the RPD. Does that preclude myself to perform sort? Are there other ways around it? Thank you.

Hello Christian, Thanks for reaching out. Could you help show how I can access the sort order column panel per your imgur link please? Per enclosed 2 screenshots I have not been able to find where I can enter formula to perform the sort function. If I access the "New Calculated Item" panel, which Oracle function could I…

Thanks for the chaser information. All the best.

The remark is super helpful in enabling me to realize I am working in logical SQL, and why standard SQL didn't work. Thanks for the link to the Logical SQL manual as well. Although the below code still didn't work, I hope posting it here will help lead and inspire others to complete their cases: IFNULL ( Raw Materials,…

Thanks for reaching out Nathan and offering the brute force method. The sample chart is a simplified version of my case, which has dozens of products and they change periodically. Thereby manually coding each item code might not be applicable in my case. However I really appreciate your time to type out your solution,…

Hello Fernando, No worries. Tks for reaching out. The business case is inventory planning. The goal at this step is to try to consolidate into the same item numbers for products that are identical physically, but are being assigned with different item codes base on case pack quantity. For example, a product by itself is…