Category Archives: Uncategorized

GlamEgo April Summer Icecream Box Review

Summer’s are back with fan to flames and will intensify with time passes. This weather is worst for skin and requires lot of care. There’s no doubt that the bulk of the skin damage happens in the summer months.Whether you’re driven by medical concerns, beauty, or both, gear up for April’s Glamego box which is amalgamated for providing you full coverage from chilly heat.

This time i loved the best was their Packaging, which clearly depicts the cool effect stored inside the box in form of beauty products, chosen especially for you. Every month they decide upon a theme and this month its about chill icecream to sooth the hotness of summer. As you can see in my pictures, lime colored box with pink icecream depicted. The box quality is lot improved and seems worthy holding it. It comes with a magnetic lock this time to make it easy to use. Its re-usable for long and hold other things.

This makes the products more appealing and loveable. So now moving on to the products. This time they have added a new skin product to their existing subscription box, so now you get 5 products on the cost of 4. This month we have:

  1. Island Kiss Black Rose & Grenade Rouge Lip Moisturizer Stain
  2. NELF Aqualite Fairness Compact Powder with UV & SPF 18
  3. Wild Turmeric Anti-Tan Treatment
  4. Vedic Line Gold Facial Kit
  5. Natural Bath & Body Sea Clay Masque

Island Kiss Black Rose & Grenade Rouge Lip Moisturizer Stain

Stepping out for a Party, and looking for a seductive lip potion? Black Rose Grenade Rouge will help moisturize, protect & stain your lips naturally. Simply squeeze some Island Kiss onto your lips and watch them stain your lips red within seconds.It costs 499 INR for 14gm of the tube.Its scent seems to draw a graceful path-so like that of an elegant woman, fond of seducing a dark night. Best part of it is its 100 % Natural and petroleum free. Its Paraben and Sulphate Free.

Its ingredients are Tropical Kokum & Avocado Butter, Organic Beeswax, Stevia, Organic Carrot Seed Oil, Pure Castor Oil, Rich Vitamin E Oil, Organic Macadamia Nut Oil, Black Rose Essential Oil, Pomegranate Seed Oil, Natural Organic Color. I got the Vanilla and lavender flavor, which gives an amazing hue to my lips. Its a beautiful shade and aroma is yumm.

DSC_2183

2. NELF Aqualite Fairness Compact Powder with UV & SPF 18

I have already tried many products from the this brand NELF Cosmetics, which have turned to be amazing like their foundations, Eyeliners.Now i got their Compact Powder to try. Since my choice was asked , so i suggested the shade according to my skin type.It costs at 350 INR for 9 gm product. their products are UV protected and blends perfectly with my skin. They are skin friendly and comes in many shades. No chemicals and last for long.

i1

3. Tjori Wild Turmeric Anti-Tan Treatment

The perfect natural sun defence using age old formulation combining wild raw turmeric with natural essential oils. Forms a beautiful shield on the skin that reverses the effect of skin damaging free radicals. This can be used like a face wash or a face pack both. Its skin friendly and no chemicals inside. It helps to reduce tan and rejuvenates the skin.

Price : Rs. 525 for 50 gm

Shelf Life : 3 Years

DSC_2186

How to Use : Mix 1 spoon of it with rose-water & honey. Stir well and apply all over your face. After 15 minutes once the pack is dry, rinse well off with water.

4. Vedic Line Gold Facial Kit

I have tried fruit facial kits of herbal brands but this time, i got a chance to try something new. Vedic Line Gold Skin Care products are based on Ayurvedic concept of Rasayana Therapy for rejuvenation of body & mind. The Vedic Line Gold facial kit gives your flawless, radiating glow with a beautiful golden aura to skin. Ayurveda suggests use of Saffron, Almond, Marigold flowers, Turmeric & Sandalwood for benefits of gold, since they absorb rays of the Sun & have gold like benefit on skin.The kit comes with 6 sachets. A cleanser, scrub, cream, massage gel, pack and a moisture Serum with SPF. Since all have a purpose, it needs to be used in a proper manner. It costs for Rs. 350.

IMG-20180407-WA0013

How to use:

1. Cleaning – Clean your face with cotton pad dipped with Green Apple Toner. In Winter, Face can be cleaned with warm wet towel. With a few drops of GoldOjas Cleanser, gently clean your face

2. Cleansing- With a few drops of GoldOjas Cleanser.

3. Exfoliating – Apply GoldOjas Scrub on wet skin. Massage lightly, avoiding eye areas & clean it.

4. Nourish your skin :

a. Massage face with Gold Ojas Cream for 8 to 10 minutes. Along with, Toner or distilled water can be used. Give right strokes & pressure, so cream gets absorbed. Wipe it.

b. Massage with Gold Ojas Massage Gel for 3 to 4 minutes. Give galvanic at positive , using Green Apple Toner. Do not clean it.

5. Rejuvenate – Apply Gold Ojas Pack After 8 to 10 minutes, Spray with toner, lightly massage & clean the face.

6. Protects & Give glow- With a few drops of Gold Ojas Moisture Serum.

5 Natural Bath & Body Clarifying Face Masque SEA CLAY

Sea Clay Mask is a rejuvenating blend of Sea Clay, Kaolin, Rhassoul and Bamboo Charcoal. Rosemary Powder gently exfoliates, leaving your skin feeling renewed and so smooth! Sea Clay – a gentle exfoliant that naturally softens, moisturizes & improves the appearance of your skin leaving it feeling more toned and clearer.Suitable for all skin types and is an excellent detox treatment.

How to use: Spread over face, avoiding eyes. To exfoliate, massage into skin with gentile circular motions. Rinse with water before mask is fully dry. Use 1-2 times per week for smooth, renewed skin!

DSC_2187

So this is what my April Box contains covering every bit of this heat summer and making it cool for me. Do subscribe to this monthly beauty box and enjoy your summers.

Subscribe to Blog via Email

Hello beautiful! Why not Subscribe to my blog and get all latest updates over your email without missing on DIY tips.

Advertisements

Valentine’s day jewellery collection from Pristine Fire.com

          Celebrate the season of love with Pristine Fire’s Valentine’s day Collection

Curate personalized jewellery for your better half with customized engravings of love messages and initials of your loved ones

Pristine Fire has launched their ‘Hearts’ collection of fine jewellery for Valentine’s Day, celebrating the concept of love. Crafted to finesse, the Valentine’s Day collection is everything you ever wished for.

Each piece in the ‘Hearts’ Valentine collection is carefully crafted to celebrate love and romance. This valentine collection offers a flavor of love in the form of uniquely crafted pendants, rings and earrings in white, yellow and rose gold with embedded diamonds. Indulge in the essence of love with exquisite diamond jewellery encrusted in heart shapes and 18kt Gold.

We also offer customized engraving on rings for up to 15 characters. You can get love messages such as “Will you marry me”, “I love you”, “My Valentine”, and initials of your loved ones engraved to add to the romance and fun.

The exclusive collection is priced affordably, and can be worn daily as a constant reminder of your partner. Charming and contemporary, the ‘Hearts’ collection makes the perfect gift for your beloved this Valentine’s Day. On the most romantic day of the year, woo your Valentine with a gift from Pristine Fire Jewellery only at www.pristinefire.com.

Jewellery

Overview of Pristine Fire:

Pristinefire.com is an online diamond jewellery store under the brand name Pristine Fire Lifestyle Pvt Ltd; a company with six decades of promoters’ experience. They bring together their long term experience in the gems & jewellery industry to provide you with a convenient and hassle-free way to buy jewellery.

Pristinefire.com offers a wide variety of exquisitely crafted rings, earrings and pendants embellished with natural diamonds and set in white, rose and yellow gold. Each piece is crafted in 18k gold and studded with diamonds certified by SGL. They aim to provide jewellery buying experience that is reliable, attractive and offers a competitive price.

For More Information: https://www.pristinefire.com/.

About the Brand:

Their presence in both domestic and international markets for decade, gives them the edge to deliver the finest product available at a competitive price and in the most convenient way possible.The first company of the group was established in Calcutta in the 1950’s. Its core activity was trading polished diamonds and gemstones between India, Nepal, Burma, and Bhutan. In the mid 1970’s they shifted their base to Mumbai and established trade with the heart of the global diamond trade in Antwerp, Belgium. Soon after, their first manufacturing units were opened in Mumbai and Surat. In the 1980’s they introduced automated diamond polishing machines making them the first company in India to do so. Around the same time the group’s sales office in New York was opened.

Today, Pristine Fire does both manufacturing and trading of diamonds and fine jewellery.Manufacturing of diamonds involves the cutting and polishing of rough diamonds into polished diamonds – the type of diamonds that consumer recognize. Trading involves both the import and export of rough and polished diamonds, and fine diamond jewellery. They export their products to the world’s largest diamonds markets, including the USA, the Middle East, parts of Europe, and Russia.

Pristine fire offers a wide variety of exquisitely crafted rings, earrings and pendants studded with diamonds and set in gold. They have collections ranging from cocktail rings for an evening out to alphabet pendants for everyday wear as well. These beauties can be customized in a choice of three most popular diamond qualities, gold karat (14 karat or 18 karat) and gold color (white, yellow, pink). Each piece of jewellery is certified by laboratories like SGL and IGI that are hallmarked as per the BIS standards.

Pristine Fire aims to provide a jewellery buying experience that is reliable, attractive and one that offers you a competitive price.

 

 

Its AmPm cafe time | DLF Galleria

Hello friends..so here i am with my review of the buzz restaurant now a days, AmPM cafe-bar. Its has 2 outlets in north, one in DLF Galleria gurgaon and other in Rajouri Garden Delhi. Its a famous restaurant chain worldwide. Since weekend is the time for lepaking, and i wanted to kill my time with old buddies, thought of visiting this place !!

Its located at 3rd floor back side of DLF Galleria, Gurgaon. Its has capacious space with both indoor and outdoor seating. They have a separate area for live music, which not only adds liveliness to evening but also makes them more relaxing & peaceful. They serve lot of delectable & scrumptious food along with shakes and cocktails. Hence this place is best option to hangout with friends and family both.

We started with the lickables, which are launched newly like Benaras Belle(5/5), which is a thick duo of gulkand and kulfi, flavored with Paan syrup.It was presented with a paan leaf & tasted amazing, so a must try. Next we had Ms. Alphonso(4/5), the most awaited drink of the visit as its a mango season and this had Mangoes flavored with icecream, presented in a luscious way! Next one was thought to be a common Orchard Street (5/5), but it turned out to be toothsome with its tutti fruityyyy flavor.

In food,we tried many dishes like AmPm chaat, Palak patta chat, Daal makhana platter, momos, Paneer tikka platter, keema pao, veggie pizza & tangy tomato pasta. Everything was lip smacking and worth the try. Delicious & authentic to flavors.

Last but not the least, we ended our day with AmPm special shakes like Kitty Katty, Belgian Affair & Magnum Upside down. Last one is the winner of tonight’s food visit !!

Find this at:

AMPM Café & Bar Menu, Reviews, Photos, Location and Info - Zomato

 

What the ratings stand for: 5 = Excellent, 4 = Very Good, 3 = Good, 2 = Fair, 1 = Disaster.

© Follow me on Instagram – creativeme1807
© Follow me on Twitter – @EktaSethi1807
© Follow me on Zomato – www.zomato.com/foodofy© Follow for more content: creativeme1807.wordpress.com
© Follow me on Facebook – https://www.facebook.com/Creativeme1807.wordpress/
Don’t forget to share this post with your social media friends by clicking one of the sharing buttons below. A quick share on Facebook would be nice for all the effort we put in.

How to get YYYYMM format from calendar date without using CAST as Char

So today i am here to discuss the scenarios of CAST function in OBIEE11g or 12c both. We always see that we always run behind using CAST function for conversion to Char/Int/Date etc. But issue appears when we have to get a diff format in Date functions.

For example, i had a scenario where user wanted to see report in pivot form, with Prompt  Date range as 2017 / 01  to 2017 / 04.

I tried getting above values in Prompt by using Convert Calendar date to Char using Cast function. But when i have to pass this prompt value to my report, it was not working as expected. If  i select Date range from 2017 / 01  to 2017 / 04, it use to show only data in report for 2017 / 01 , 2017 / 02, 2017 / 03.  It use to omit 2017 / 04.

To resolve this issue, we used a simple logic in Report Prompt, as below. This gives us the output in little different format , but still no CAST is used,so no conversion to Char and then having issues passing value.

Using below idea, we are now able to get output in proper format and it passes correctly to report and filters it.

imgg

Output shows below:

Follow for more 🙂

How to navigate to external links from obiee reports

Sometimes we get different business requirements, which are meaning-full but little trick to implement in OBIEE. Similarly , last week i got a requirement for business to add a hyperlink on a report column, which when clicked goes to an external link. also, along with it i have to pass the CodePin and Number.

I tired many ways of passing parameters in Go Nav, GO url format. But it didnt work. Finally <a Href> worked, so sharing my solution with you.

Step 1: Edit column formula and place your code in below format. Concat all the parameters to be passed. Set Target and give it a name.

Step 2: Modify the same column and set its data format as below.

Let me know if you face any issues.

Follow for more !!

 

Mughal Dine-esty…the fine Dining Restaurant !!

Mughal Dine-esty is a fine dining restaurant on the ground floor of the Time Square Building in Sushant Lok Phase 1 in Gurgaon. It’s an add-on venture of Dine-esty, which has been a famous Chinese restaurant in Gurgaon. This restaurant serves authentic Mughalai food. This place has a common entrance and 2 different set-ups inside. The interiors are exquisite and really aesthetic.You can see chinese theme touch in the seating area.

The restaurant offers a good variety of food options in both Chinese and Mughlai Cuisines.  Visited here for fine dining with my husband & friends on Sunday brunch.We tried both vegetarian and non vegetarian cuisines.

We started of with the starters, along with some signature drinks like Italian Smooch, Silver Lining, Blue Sea and Food Punch (5/5). Both the cocktails and mocktails were full of flavors and tasted well. In starters, we had Methi corn ke seekh kebab (5/5) –full of flavours and yumm, Kale channe ki Tikki (4.5/5) – was nicely cooked ,had strong flavour of Cardamom & was quite crispy , Daahi ke Sholley (5/5) – very cripsy and full of hungcurd, properly fried, Achari Paneer Tikka (5/5) was teh best i liked. Paneer was very soft and full of flavours.

After drinks and starters, it was time to order main course. We ordered Daal Makhani, RawalPindi Cholle, Keere ka raita, Rice & Naans.Food was delicious (5/5) and the portion size was also good. In desserts we had gulab jamuns which were quite soft and served hot.

collgg1

The staff is pretty courteous in service and the service was prompt. Pricing wise little costly but worth a visit.

Highly recommend as place is ideal for fine dining, especially with your family.

 

To know more about Mughal Dine-esty, click here:

Mughal Dine-Esty Menu, Reviews, Photos, Location and Info - Zomato

La Pino’z..What more you can ask from a pizza !!

La Pino’z pizza is a delivery only outlet serving delicacies like Mexican, Italian, chinese. It’s located at Golf course road, gurgaon. Their priority is to serve high quality, freshly prepared, hot meals delivered on time, every time to all of their customers.

They serve authentic pizzas at a very reasonable price.Menu has lot of options including veg and non veg. Order was delivered on time and served hot. The packaging was proper, cardboard boxes with required accompaniments. La Pino’z Pizza is one place where you can try the Giant Slice if you’re looking to try more than one pizza or do not have the appetite to eat it all. You can also ask them to serve two favours on same pizza. They have given an option to order Monster pizza, for large group of people.

We ordered Cheese garlic bread (5/5), which was as super yummy,full of cheese and adequately flavoured. Corn Taco’s (4.5/5) – it was excellent and full of cheese, corn.was properly cooked and crispy. 1 large Veg Tamer pizza & 1 paneer pizza (5/5).Pizza were really good with full on veggie toppings like onion, tomatoes and capsicum, paneer,mushrooms . It was super yum. The crust was not too thick and quite crispy, It was served with delicious dips and sauces.

collg

I shared my order with my parents. Generally, we don’t eat outside or ready meals, so i was skeptical about how good the food would taste, i feared they my parents will not like it, but was soooo happy when my father said I just loved the Pizza. Everything were delicious & lip smacking!!

Loved the food and would highly recommend it!!

What the ratings stand for: 5 = Excellent, 4 = Very Good, 3 = Good, 2 = Fair, 1 = Disaster.

Find it on Zomato at :

La Pino'z Pizza Menu, Reviews, Photos, Location and Info - Zomato