Michelle Mangion
- Total activity 51
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 2
- Subscriptions 24
Activity overview
Latest activity by Michelle Mangion-
Michelle Mangion created a post,
CREATING A FIXED TIMESTAMP FOR field 'created at'
Hi, I need to get a timestamp (year,month,day) would be enough for every new record being created. This needs to be fixed to the created date of the record and would not change with every elasti...
-
Michelle Mangion commented,
Hi Charlotte, I don't know if there is a way I can insert a field into a fact table whereby I grab the current date just once for every new record created. The timestamp would not change after tha...
-
Michelle Mangion commented,
Deleting the hierarchy has been resolved, however as Glenn previously stated there is no way to delete a field.
-
Michelle Mangion commented,
Hi, I also need to know how to delete a line of hierarchy. I might also be overlooking the option as I can only see Add Hierarchy. Assistance is very much appreciated. Michelle
-
Michelle Mangion created a post,
adding SQL function for date conversion to number
HI, Currently one has to get a date conversion using soemthing like this: ===================================== (getyear(CreationDate)*10000 + getmonth(CreationDate)*100 + getday(CreationDate) ...
-
Michelle Mangion created a post,
Adding a build at the end of month
I would like to have a functionality that allows for a build in a elasticube attached to end of month (EOM). Since not all months end on the same day, further complex SQL code is needed to achiev...
-
Michelle Mangion created a post,
Adding confirmation on a table bin icon
In the elasticube once you hit on the delete icon (bin) on a table, the table gets deleted automatically without asking for a confirmation. This is extremely risky as I have hit on this accidental...
-
Michelle Mangion commented,
Hi, My cube is experiencing the same problem and none of the suggestions above have worked for me. I am using version 6.7. Can someone please tell me a way to cancel the build, it's been going on f...
-
Michelle Mangion created a post,
How to extract data from 3 tables when some records may not exist in the last 2 tables
I have a query which uses all records from Table A having a LEFT Join on the other 2 tables. My issue is that there are some records which may not exist in the other two tables. I am attaching an i...
-
Michelle Mangion commented,
I also need to do a SELECT using the EXCLUDE, any update on this feature please?