Hi, What piece of product are you using? Is this a Publisher report? Is this a "classic" analysis? Is this a DV workbook? What product (OAS or OAC?) and version are you using? The category where you posted and the tags are contradictory…

While they are only sample commands, you definitely don't want to run this one: ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; Changing the default profile to never expiring passwords isn't something you want in your database. Let your DBAs handle the passwords lifecycle of your schemas. All you need to know is:…

@Rashmi Jadhav-Oracle , you seem to be working with a DV workbook (always better to say, when you ask a question, which part of the product you are using: DV workbook, "classic" analysis or Publisher report, and also what product: OAC or OAS as they have different features). Some features that exists for more than 10 years…

Is it possible to have the downloaded file not showing the adobe logo? There is nothing that Publisher can do, because it's your Windows doing that (if I do download a .catalog on my Windows, it shows as an unknow type of file, with just a white file icon, because I never associated .catalog with any software on my PC).…

a requirement for a table with columns like city, month1, month2, and so forth. If you want a table with a dynamic number of columns, then use a pivot. and your data shouldn't physically be stored in multiple column but by rows (for example with a single "date" column saying what date the value is for). If you display that…

@BalagurunathanBagavathy-Oracle , no need to repost, yours has been marked as accepted as per OP comment.

@Mirithu , Do you mind starting a new question with what you look for? This is an old abandoned thread, and based on the reply I posted it has been imported in this forum from a previous forum where it was in the OAD category. Post a new question with all the details of your case (product name and version), what issue you…

Well … because you can define the physical tables manually, creating one column after the other, that's also a way to define the order of your physical columns (therefore the option to visually sort them A-Z or not). But I would say the option to uncheck the sort of physical columns in that list is more a generic feature…

If the order in the physical layer is a key element for you, copy the table to a text editor, reorder the columns as you need them in the table definition (you can also script that if you have 276 and you want the order of your database) and paste it back in the RPD (rename the existing table, to avoid a mess with…

In the physical layer there isn't a real concept of "order", you can't move columns up and down (maybe, unchecking the sort option, if you change the table definition it will keep that order, but it's a maybe still). The order of columns starts being a real thing in the logical layer, where you can explicitly set the order…

Sometime the best is only say "not possible" 😉 Don't go into using text prompts for dates, or be ready to answer 10 questions a day why the filter isn't working for ddmmyy, mm/dd/yyyy, dd-mm-yyyy etc.

Thanks for the edit of the question to make it more clear. I'm sure you will soon get some valid replies (Sunday is a bit calmer than the rest of the week, but who knows…)

Hi @Zuhair Amjad , Is this a question or you were trying to post some findings on how to change the behavior you describe but the main part of your post "disappeared" ?

then imported snapshot of OAS 5.5 Did you import the security as well? Then you just removed the required policies from your application role, because semantic modeler didn't existed in OAS 5.5 and therefore the require policies weren't there. You always should be extremely careful when imported older version snapshots if…

It's the main catalog table css_si_files in the biplatform schema. But as said, the privileges are missing that info on the modification.

OP did post an idea, if you are interested in the same go there and upvote it.

Because the privileges are stored in the catalog, if the fields of "modified_by_name" and "modified_by_type" would behave like everything else in the catalog, the job would be done already and could be tracked with database auditing. But apparently for the privileges these attributes of the catalog objects stay null all…

Please do not double post! And also post in the right category (you posted in Publisher and in Business Intelligence instead of the OAS one).

Is this really different than your other thread?

@Sarah Beckwith-Oracle , OAD isn't really the product of this thread (OP is using OAC), but OAD is just a "lightweight" OAS running on your desktop. The usual log files exist, for example in C:\Users\<your user>\AppData\Local\Temp\DVDesktop\logs\OBIS you can find obis1-query.log that does contains queries etc.