Category Archives: Uncategorized

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.

 

 

Advertisements

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

Buéno café…Premium bakery & Sandwich café !!

Buéno café is located in MGF Metropolis mall, Gurgaon. It is a healthy café that serves some delicious desserts & healthy sandwiches. Along with it, the best thing i loved is their presentation. Food was delivered in white packages stating…..Premium bakery & Sandwich café !!

This place is a newly opened delivery outlet & serves the best of their kind. We recently got to order few food items from Bueno & everything was lip smacking.
Packaging: Loved the packing. Most of it was packed in little jars with their labels. Sandwiches were packaged and sealed nicely with no leakage. It was easy to handle and had veg/ non veg mentioned properly on them. The cookies , Hummus ,Cheese cake and Banoffee were packed in an airtight glass bottle with Lid and was vacuum packed.

Food: We ordered the Assorted Pita chips” target=”_blank”>Pita chips with Hummus. They were colorful and square shaped baked chips. The flavor combination with Hummus sounded so good. The chip has a hearty crunch and really work well with all sorts of dips. Then we tried their variety of cookies like Double Chocolate chip Cookie & Tender Coconut cookies: These were scrumptious crispy mini cookies filled with chocolate chips. They were nicely packed in glass jars. They added to best of the appetizer’s.

collage1

Next we had the Veg club Sandwich ,which had multi grain bread well stuffed with veggies(onion, tomatoes),mustard and slices of the mozzarella cheese. The best part was the bread was very soft and was not overstuffed.

In desserts we had Banoffee & Blueberry Cheese cake. It was worth binging for. I enjoyed every scoop of it and finished till the end. After all it was my fav and tasted yummy . It s must recommendation.
Delivery time: Food was delivered on time .The Server was very humble & polite.

Prices: Little over priced but worth every bit, as they maintain good quality food.

Follow me on Zomato

Find it on :
buéno Menu, Reviews, Photos, Location and Info - Zomato